| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hundred Seperator in Excel
Hi Everyone,
Well I came accross a question, to beign with is that Excel uses Thousands a seperator giving figures in millions and Billions, However I want to have figures in Thousands and Lakhs and crore.. EX: There is a figure 123456789 that will appear in excel as 123,456,789.... Right... But i want to have it as 12,34,56,789...... So is it possible..... Thanks K****ij |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hundred Seperator in Excel
In MS Excel , (comma) denotes thousands separator. Try the below add-in to
convert to Indian format.. http://www.dq.winsila.com/tips-trick...and-words.html If this post helps click Yes --------------- Jacob Skaria "K****ij" wrote: Hi Everyone, Well I came accross a question, to beign with is that Excel uses Thousands a seperator giving figures in millions and Billions, However I want to have figures in Thousands and Lakhs and crore.. EX: There is a figure 123456789 that will appear in excel as 123,456,789.... Right... But i want to have it as 12,34,56,789...... So is it possible..... Thanks K****ij |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hundred Seperator in Excel
Hi Jacob... Really thanks for the same......
I appreciate your response..... Thanks "Jacob Skaria" wrote: In MS Excel , (comma) denotes thousands separator. Try the below add-in to convert to Indian format.. http://www.dq.winsila.com/tips-trick...and-words.html If this post helps click Yes --------------- Jacob Skaria "K****ij" wrote: Hi Everyone, Well I came accross a question, to beign with is that Excel uses Thousands a seperator giving figures in millions and Billions, However I want to have figures in Thousands and Lakhs and crore.. EX: There is a figure 123456789 that will appear in excel as 123,456,789.... Right... But i want to have it as 12,34,56,789...... So is it possible..... Thanks K****ij |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use 100 seperator instead of 1000 in excel | Excel Discussion (Misc queries) | |||
| Dropdown entry seperator question for Excel XP? | Excel Discussion (Misc queries) | |||
| Combining a few hundred excel files into one | New Users to Excel | |||
| Excel 2002 -Merging cells contents in with a comma seperator | Excel Discussion (Misc queries) | |||
| import .CSV file to XP EXcel 2003 worksheet, the seperator is com. | New Users to Excel | |||
Linear Mode
