Statistical: Custom Format of numbers

lambuhere1 · Jun 26th 2003

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

Neale · Jun 26th 2003

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

HTH

lambuhere1 · Jun 26th 2003

Neale, I did try your option. It doesnt work. I get a comma in the cell instead of the number.

Thanks

Ram P

Neale · Jun 26th 2003

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

h · Apr 23rd 2005

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"

**norie** · Apr 23rd 2005

Re: Statistical: Custom Format of numbers

helmekki

To format a variable use the Format function.

Statistical: Custom Format of numbers

Participate now!

Share