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