Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Want to use 100 seperator instead of 1000 seperator
I want to represent ten crores as 10,00,00,000
instead of 100,000,000 in Microsoft Excel Can anybody help? |
#2
|
|||
|
|||
Ilango,
Maybe you didn't notice that this is a Word forum, not an Excel forum! FWIW, In Excel, you could use either: .. a custom number format, as in 00\,00\,00\,000 or #\,00\,00\,000 .. a text formula, as in =TEXT(100000000,"00\,00\,00\,000") or =TEXT(100000000,"#\,00\,00\,000") Cheers "Ilango" wrote in message ... I want to represent ten crores as 10,00,00,000 instead of 100,000,000 in Microsoft Excel Can anybody help? |