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

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

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

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

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

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