Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Divide selected cells by 1000
I have a spreadsheet with all values in $ and I need to convert it to
thousands ($K). Is there a way I can simply enter 1000 in a cell on my spreadsheet, select all the values and divide them all by that cell? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Divide selected cells by 1000
Sure, try the following...
1) Select an empty cell 2) Enter 1000 3) Edit Copy 4) Select the range of cells containing the values 5) Edit Paste Special Divide Ok Hope this helps! In article , Lowkey wrote: I have a spreadsheet with all values in $ and I need to convert it to thousands ($K). Is there a way I can simply enter 1000 in a cell on my spreadsheet, select all the values and divide them all by that cell? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Divide selected cells by 1000
Yes.
Enter 1000 in an empty cell. EditCopy. Select your values. EditPaste Special, check Divide -- Kind regards, Niek Otten "Lowkey" wrote in message ... |I have a spreadsheet with all values in $ and I need to convert it to | thousands ($K). Is there a way I can simply enter 1000 in a cell on my | spreadsheet, select all the values and divide them all by that cell? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Divide selected cells by 1000
That should be...
1) Enter 1000 in an empty cell 2) Select this cell 3) Edit Copy 4) Select the range of cells containing the values 5) Edit Paste Special Divide Ok In article , Domenic wrote: Sure, try the following... 1) Select an empty cell 2) Enter 1000 3) Edit Copy 4) Select the range of cells containing the values 5) Edit Paste Special Divide Ok Hope this helps! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Divide selected cells by 1000
Or maybe keep the value, but give the cells a custom format of:
#, (end with a comma) Lowkey wrote: I have a spreadsheet with all values in $ and I need to convert it to thousands ($K). Is there a way I can simply enter 1000 in a cell on my spreadsheet, select all the values and divide them all by that cell? -- Dave Peterson |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Divide selected cells by 1000
What a nice addition!
-- Kind regards, Niek Otten "Dave Peterson" wrote in message ... | Or maybe keep the value, but give the cells a custom format of: | | #, | | (end with a comma) | | | | Lowkey wrote: | | I have a spreadsheet with all values in $ and I need to convert it to | thousands ($K). Is there a way I can simply enter 1000 in a cell on my | spreadsheet, select all the values and divide them all by that cell? | | -- | | Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
How do you divide two cells in a pivot table to equal a %? | Excel Worksheet Functions | |||
Macro, Copy Selected Cells Down a Column | Excel Discussion (Misc queries) | |||
one cell's value Highlights selected cells....how? | Excel Discussion (Misc queries) | |||
how can I duplicate or copy a workbook then divide selected cells. | Excel Discussion (Misc queries) |