|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 20th, 2009, 07:10 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
Separator
Hello,
Myself Mukesh Kumar, I am using MS Excel 2003. My question is that I want value in the format which I want. Just like this 12,45,36,789 but MS Excel provide separator after every thousand value. If there is any solution of this problem than tell me on my e-mail address 
|
|
#2
November 20th, 2009, 08:04 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Separator
Type the number 124536789 in a cell and do right click and select Format
CellsNumberCategoryCustomType (paste this format) ##\,##\,##\,##0Hit Ok… If you want to show the 2 decimal places, then add .00 on it… ##\,##\,##\,##0.00 If this post helps, Click Yes! -------------------- (Ms-Exl-Learner) -------------------- "M.K. Saroy" wrote: Hello, Myself Mukesh Kumar, I am using MS Excel 2003. My question is that I want value in the format which I want. Just like this 12,45,36,789 but MS Excel provide separator after every thousand value. If there is any solution of this problem than tell me on my e-mail address
|
|
#3
November 20th, 2009, 10:37 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Separator
In 2003. Easiest way is to select cells; click on Format on the MENU BAR
Cell Number tab uncheck the '1,000 separator' box OK -- Cheers, V "M.K. Saroy" wrote: Hello, Myself Mukesh Kumar, I am using MS Excel 2003. My question is that I want value in the format which I want. Just like this 12,45,36,789 but MS Excel provide separator after every thousand value. If there is any solution of this problem than tell me on my e-mail address
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
