| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dividing multiple cells by 1000
I have a large spreadsheet and want to see the numbers in thousands. Is
there a way to highlight all the cells and divide them all by 1000 without going into each cell? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dividing multiple cells by 1000
Enter 1000 in any blank cell and copy select your range right click Paste
Special Divide OK out "Debbie" wrote: I have a large spreadsheet and want to see the numbers in thousands. Is there a way to highlight all the cells and divide them all by 1000 without going into each cell? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dividing multiple cells by 1000
Thanks. That was so easy.
"Teethless mama" wrote: Enter 1000 in any blank cell and copy select your range right click Paste Special Divide OK out "Debbie" wrote: I have a large spreadsheet and want to see the numbers in thousands. Is there a way to highlight all the cells and divide them all by 1000 without going into each cell? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dividing multiple cells by 1000
You're Welcome!
"Debbie" wrote: Thanks. That was so easy. "Teethless mama" wrote: Enter 1000 in any blank cell and copy select your range right click Paste Special Divide OK out "Debbie" wrote: I have a large spreadsheet and want to see the numbers in thousands. Is there a way to highlight all the cells and divide them all by 1000 without going into each cell? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dividing multiple cells by 1000
Try formatting your cells like this:
##0, "Debbie" wrote: I have a large spreadsheet and want to see the numbers in thousands. Is there a way to highlight all the cells and divide them all by 1000 without going into each cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dividing cells | Excel Discussion (Misc queries) | |||
| Dividing cells by 1000 | Excel Discussion (Misc queries) | |||
| Multiples of 1000 in cells? | Excel Discussion (Misc queries) | |||
| Dividing up cells | Excel Discussion (Misc queries) | |||
| Dividing a value list equall among multiple persons | Excel Discussion (Misc queries) | |||
Linear Mode
