| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dividing cells by 1000
I have a document in which I have to do my report in thousands i.e. $1000
represents $1,000,000. How do I divide each data cell by 1000 without individually dividing each cell by 1000? -- Django |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dividing cells by 1000
Enter 1000 in an unused cell.
Copy that cell then select your range of cells to change. EditPaste Special(in place)DivideOKEsc. Clear the cell with the 1000. OR if for visual appearance only or printing, custom format the cells to #, Gord Dibben MS Excel MVP On Sat, 25 Aug 2007 07:24:01 -0700, Django wrote: I have a document in which I have to do my report in thousands i.e. $1000 represents $1,000,000. How do I divide each data cell by 1000 without individually dividing each cell by 1000? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dividing words in selected cells | Excel Worksheet Functions | |||
| Multiples of 1000 in cells? | Excel Discussion (Misc queries) | |||
| Dividing linked cells | Excel Worksheet Functions | |||
| Dividing Cells & Averages | Excel Discussion (Misc queries) | |||
| Dividing up cells | Excel Discussion (Misc queries) | |||
Linear Mode
