Reply
 
Thread Tools Display Modes
  #1   Report Post  
Ilango
 
Posts: n/a
Default 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   Report Post  
macropod
 
Posts: n/a
Default

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?



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 02:06 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"