In excel 2003 format like 12,34,567
From the newsgroup archives, this answer from Bernard Liengme:
Format Custom as
[=10000000]##\,##\,##\,##0.00;[=100000]##\,##\,##0.00;##,##0.00
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"hirendra7158" wrote in message
...
| how do i format currency to display 12,34,56,789.00 instead of 123,456,789.00
| Please mark placing of Thousand separator .
|
| I have Regional and Language Options set up in my way, but excel still does
| not return my way. I have checked "use system seperator" on.
| thanks,
|