number format macro

  1. C

    VBA Number Format Toggle

    I am trying to do a toggle shortcut key for number formats. I have come up with the below but the only issues is if the existing number format is not one of the below it will not start the toggle. I keep getting an error "Case Mismatch on the 2nd Case (after the "Case All") Sub AlexNum()...
  2. F

    text bullets and numbering

    Hi, I have added Textbox into PPT and I want to put there a text with few line - each should be marked by bullet (dot or circle) or by number (like 1, 2). Example: 1. Some long text 2. Other text etc.... How can I do it? activeSlide.Shapes.AddTextbox msoTextOrientationHorizontal, Left:=0...
    • Forestq
    • Thread
    • bullets bullets and numbering number format number format in text number format macro
    • Replies: 1
    • Forum: Excel Questions
  3. S

    convert number stored as text to number without rounding the numbers

    Hi All, I am looking for a VBA code for the below issue, Please help. I am stuck where i have to convert the number which are stored as text and i have to convert them in number format and it should not round up the numbers. Below is the sample data for your reference. once data gets convert...
  4. S

    VBA: Set Decimal Places from Input Value

    Hello, I am working with a macro that take three input values (min, max, decimal places) and returns random numbers within those bounds to a selected area. Sub RandNums() 'http://excel.tips.net/T002077_Generating_Random_Testing_Data.html 'creates random numbers within selection 'constraints...
  5. G

    Help with 2 macros

    Hi, Wondering if anyone can help with 2 macros I have that work but both have kinks that I would like to check 1) Number format macro ................ Selection.NumberFormat = "#,##0;[Red](#,##0);-;" This macro is for formatting numbers in a way I like. However if I inadvertantly use it on...
    • GusC
    • Thread
    • macro help number format macro round formula
    • Replies: 2
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top