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