Format Custom as

[=10000000]##\,##\,##\,##0.00;[=100000]##\,##\,##0.00;##,##0.00

(From Bernard Liengme)


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Rhythm" wrote in message ...
| how to convert the numbers in currency ie Rupee format in Microsoft Excel
| 2003 Version