Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing number formats without rebuilding worksheet
I've got numbers formated like the following 197.9 and it should be 197,900.
I'm looking ofr a way to change the whole sheet. thanks Joe |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing number formats without rebuilding worksheet
You can select a block of cells, or even the entire sheet, and change the
number format of the selection all at once. Select the small square left of the column letters and above the row numbers to select the whole sheet, go to Format menu Cells... Number tab, select Number under Category, change Decimal Places to zero, and check the Use 1000 Separator box. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Joe" wrote in message ... I've got numbers formated like the following 197.9 and it should be 197,900. I'm looking ofr a way to change the whole sheet. thanks Joe |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing number formats without rebuilding worksheet
Enter 1000 in an unused cell.
Copy that cell the selct the range of numbers to change. EditPaste SpecialMultiplyOKEsc. 197.9 will become 197,900. Gord Dibben MS Excel MVP On Wed, 17 Jan 2007 05:25:01 -0800, Joe wrote: I've got numbers formated like the following 197.9 and it should be 197,900. I'm looking ofr a way to change the whole sheet. thanks Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
How can i paste a 16 digit number in a excel worksheet? | Excel Discussion (Misc queries) | |||
Changing default worksheet tab fonts | Excel Discussion (Misc queries) | |||
Changing format of number without changing the value | Excel Discussion (Misc queries) | |||
Maximum Number of Cell Formats | Excel Discussion (Misc queries) |