number format macro

  1. 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...
  2. 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...
  3. 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...
  4. 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...

Some videos you may like

This Week's Hot Topics

Top