Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Thousand Seperator
How do i go about formating a number to be displayed as
12,34,56,789.00 INSTEAD OF THE 123,456,789.00 -- Thks |
#2
|
|||
|
|||
You are probably m issing the esc character
##\,##\,##\,##0.00 -- HTH RP (remove nothere from the email address if mailing direct) "venky" wrote in message ... How do i go about formating a number to be displayed as 12,34,56,789.00 INSTEAD OF THE 123,456,789.00 -- Thks |
#3
|
|||
|
|||
venky
If you want this to be the default for all Apps. you could change to that configuration in Windows Control PanelRegional and Language OptionsRegional OptionsCustomizeDigits Grouping. Gord Dibben Excel MVP On Fri, 26 Nov 2004 01:01:06 -0800, "venky" wrote: How do i go about formating a number to be displayed as 12,34,56,789.00 INSTEAD OF THE 123,456,789.00 |
#4
|
|||
|
|||
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. "Bob Phillips" wrote: You are probably m issing the esc character ##\,##\,##\,##0.00 -- HTH RP (remove nothere from the email address if mailing direct) "venky" wrote in message ... How do i go about formating a number to be displayed as 12,34,56,789.00 INSTEAD OF THE 123,456,789.00 -- Thks |
#5
|
|||
|
|||
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 "Gord Dibben" wrote: venky If you want this to be the default for all Apps. you could change to that configuration in Windows Control PanelRegional and Language OptionsRegional OptionsCustomizeDigits Grouping. Gord Dibben Excel MVP On Fri, 26 Nov 2004 01:01:06 -0800, "venky" wrote: How do i go about formating a number to be displayed as 12,34,56,789.00 INSTEAD OF THE 123,456,789.00 |
#6
|
|||
|
|||
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) "venky" wrote in message ... 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. "Bob Phillips" wrote: You are probably m issing the esc character ##\,##\,##\,##0.00 -- HTH RP (remove nothere from the email address if mailing direct) "venky" wrote in message ... How do i go about formating a number to be displayed as 12,34,56,789.00 INSTEAD OF THE 123,456,789.00 -- Thks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|