ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Number format (https://www.excelbanter.com/excel-discussion-misc-queries/177144-number-format.html)

Jamal

Number format
 
Is there a way to format number to show say 1,00,000 instead of 100,000. This
is to reflect Indian 100,000, which is called one lac. I am using Excel 2000.
Thanks for your help.

John Bundy

Number format
 
Not tested, but look here

http://www.dq.winsila.com/tips-trick...and-words.html
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Jamal" wrote:

Is there a way to format number to show say 1,00,000 instead of 100,000. This
is to reflect Indian 100,000, which is called one lac. I am using Excel 2000.
Thanks for your help.



All times are GMT +1. The time now is 03:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com