| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Divide Cells on a spreadsheet by 1000
Can anyone tell me if there is a way that I can divide the cells on a
spreadsheet by 1000 without going to each individual cell and dividing by 1000. -- Django |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Divide Cells on a spreadsheet by 1000
Enter 1000 in an un-used cell
Copy that cell Select the cells ( or columns) that you want to change Paste/Special/divide -- Gary''s Student - gsnu200794 "Django" wrote: Can anyone tell me if there is a way that I can divide the cells on a spreadsheet by 1000 without going to each individual cell and dividing by 1000. -- Django |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Divide Cells on a spreadsheet by 1000
Type 1000 into a blank cell and press enter. Select this cell and click copy.
Highlight all the cells you want to divide by 1000 and then click Edit - Paste Special - Select the Divide Radio button. "Django" wrote: Can anyone tell me if there is a way that I can divide the cells on a spreadsheet by 1000 without going to each individual cell and dividing by 1000. -- Django |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Divide Cells on a spreadsheet by 1000
Thanks Gary.
-- Django "Gary''s Student" wrote: Enter 1000 in an un-used cell Copy that cell Select the cells ( or columns) that you want to change Paste/Special/divide -- Gary''s Student - gsnu200794 "Django" wrote: Can anyone tell me if there is a way that I can divide the cells on a spreadsheet by 1000 without going to each individual cell and dividing by 1000. -- Django |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiply an entire spreadsheet by 1000 without going into ea cell | Excel Worksheet Functions | |||
| divide all cells in a spreadsheet by 1.5 | Excel Discussion (Misc queries) | |||
| Dividing cells by 1000 | Excel Discussion (Misc queries) | |||
| Multiples of 1000 in cells? | Excel Discussion (Misc queries) | |||
| Divide selected cells by 1000 | Excel Worksheet Functions | |||
Linear Mode
