Thousand Seperator

V

venky

How do i go about formating a number to be displayed as
12,34,56,789.00 INSTEAD OF THE 123,456,789.00
 
B

Bob Phillips

You are probably m issing the esc character

##\,##\,##\,##0.00

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
G

Gord Dibben

venky

If you want this to be the default for all Apps. you could change to that
configuration in Windows Control Panel>Regional and Language Options>Regional
Options>Customize>Digits Grouping.

Gord Dibben Excel MVP
 
V

venky

Hi bob,

thanks for yr post. it was really helpful but i am facing a problem
for example, i use your options see below as to what happens to display

format : ##\,##\,##\,##0.00

Amount Display
100000000.00 10,00,00,000.00
100000.00 ,1,00,000.00
100.00 ,,,100.00

ie IT HAS GOT A LEADING "," . How to get rid of this now.

Thanks for your support.
 
V

venky

HI Gord,

Tks for your reply.

But i dont get the display like i wanted 1,23,45,678.00 either i can make
that as 12,345,678.00 or 12,34,56,78.00 (ie either group it in 2's or 3's)

Check back and revert

Thanks
 
B

Bob Phillips

Okay, let's trap the length as well. Try this
[>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00-- HTH
RP
(remove nothere from the email address if mailing direct)
 
Top