Statistical: Custom Format of numbers

  • Hi,


    I would like to know how to format 100000.00 as 1,00,000.00
    or 1000000 as 10,00,000.00 . I have tried changing the Regional Settings (Start --> Control Panel --> Regional Settings ; Change the Number settings).


    It doesnt work. Can anyone shed any more thoughts?


    Thanks


    Ram P

  • Check out Format > Cells - Number tab
    Select Number and then click the , comma separator check box.


    HTH

    There are three types of people in this world.
    Those who can count and those who can't.

  • Where do you want this format to appear - if not in a cell?


    You can't format with commas in the formula bar because a comma is a separator used in functions.


    If you enter a number 1,000 in Excel it will automatically be formatted with the ,


    HTH

    There are three types of people in this world.
    Those who can count and those who can't.

  • Re: Statistical: Custom Format of numbers


    how can i do this to a variable to make appear on msgbox
    as

    Code
    msgbox "not ok" & v & " Look at it"

    ******************
    [SIZE=6]Yours
    h [/SIZE]

    Your Help Is Highly Appreciated

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!