Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comma Deliminated File Format | Excel Discussion (Misc queries) | |||
Applying Indian comma style | Excel Discussion (Misc queries) | |||
Importing a part of a big comma delimited csv-file | Excel Worksheet Functions | |||
Comma is not visible in Excel | Excel Discussion (Misc queries) | |||
HELP - I need to change space delimited to comma? | Excel Discussion (Misc queries) |