Commas in indian style
How to add decimial points & can you explain this sequence of hash & zeros
"Bob Phillips" wrote in message
...
Use a custom format of
[=10000000]##\,##\,##\,##0;[=100000]##\,##\,##0.00;##,##0
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"SVC" wrote in message
...
Hi!
sample number 123456789
In excel normally numbers are seprated in 1000's format ie 123,456,789.00
I NEED IT IN this format (indian style of rupees) 12,34,56,789
|