| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use 100 separator inspite of 1000 separator in excel
Suppose A1 number is 120000.00. Now I want to separate it by 1000 & 100, i.e.
1,20,000.00. If I format the cell - Number & click on 1000 separatetor. It show like 120,000.00. Is there any custom format to show 1,20,000.00 in excel 2003 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel, how do I change the argument separator in a function fr. | Setting up and Configuration of Excel | |||
| How do we add a separator in Excel 2007 menu using VBA | Excel Discussion (Misc queries) | |||
| Save a csv or text file in Excel 2000 with choice of separator | Excel Discussion (Misc queries) | |||
| Excel separator pages | Excel Discussion (Misc queries) | |||
| thousand separator | Setting up and Configuration of Excel | |||
Threaded Mode
