ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Comma (https://www.excelbanter.com/excel-worksheet-functions/99578-comma.html)

Gary

Comma
 
Hi Experts....heres one query.

In excel, the comma (to the figures) is put as per the American System. i.e.
if I want 100000. It will be shown as 100,000.
Is there any way by which I can get it as 1,00,000.
Please let me know if this is possible

Thanks
Gary



Mallycat

Comma
 

There is no way that I am aware of. I also don't understand why you
would want to do this.

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=561908


Gary

Comma
 
I want it in Indian format.

instead of "hundred thousand"..I want "one lakh".

"Mallycat" wrote in
message ...

There is no way that I am aware of. I also don't understand why you
would want to do this.

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile:
http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=561908




Mallycat

Comma
 

Try setting your regional and Language options in Control Panel to
Hindi

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=561908



All times are GMT +1. The time now is 10:11 AM.

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