| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy & divide by
I have a spreadsheet with numbers stated as whole numbers i.e. 12,251,
25,000, 851, 55,250. I need to copy these values to another spreadsheet and divide them by 1,000 in the process to state the above numbers as 12.251, 25.0, .851, 55.250 etc. How can this be accomplished in Excel? Thanks for the help. -- Dewayne |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy & divide by
Copy to the other sheet, then put 1000 in a cell and copy that, then
select the copied values, do Paste Special, Divide. Dewayne wrote: I have a spreadsheet with numbers stated as whole numbers i.e. 12,251, 25,000, 851, 55,250. I need to copy these values to another spreadsheet and divide them by 1,000 in the process to state the above numbers as 12.251, 25.0, .851, 55.250 etc. How can this be accomplished in Excel? Thanks for the help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy & divide by
Format an empty cell as Number. Enter the number 1000. EditCopy
Select your numbers to be divided EditPaste Special, check Divide -- Kind regards, Niek Otten Microsoft MVP - Excel "Dewayne" wrote in message ... |I have a spreadsheet with numbers stated as whole numbers i.e. 12,251, | 25,000, 851, 55,250. I need to copy these values to another spreadsheet and | divide them by 1,000 in the process to state the above numbers as 12.251, | 25.0, .851, 55.250 etc. | How can this be accomplished in Excel? | Thanks for the help. | -- | Dewayne |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy & divide by
Thank you Bob
-- Dewayne "Bob I" wrote: Copy to the other sheet, then put 1000 in a cell and copy that, then select the copied values, do Paste Special, Divide. Dewayne wrote: I have a spreadsheet with numbers stated as whole numbers i.e. 12,251, 25,000, 851, 55,250. I need to copy these values to another spreadsheet and divide them by 1,000 in the process to state the above numbers as 12.251, 25.0, .851, 55.250 etc. How can this be accomplished in Excel? Thanks for the help. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy & divide by
Thank you Niek
-- Dewayne "Niek Otten" wrote: Format an empty cell as Number. Enter the number 1000. EditCopy Select your numbers to be divided EditPaste Special, check Divide -- Kind regards, Niek Otten Microsoft MVP - Excel "Dewayne" wrote in message ... |I have a spreadsheet with numbers stated as whole numbers i.e. 12,251, | 25,000, 851, 55,250. I need to copy these values to another spreadsheet and | divide them by 1,000 in the process to state the above numbers as 12.251, | 25.0, .851, 55.250 etc. | How can this be accomplished in Excel? | Thanks for the help. | -- | Dewayne |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Divide by 3 | Excel Discussion (Misc queries) | |||
| Divide by 3 | Excel Discussion (Misc queries) | |||
| divide by 0 | Excel Worksheet Functions | |||
| Divide one row over other row I dont wont to divide one number | Excel Discussion (Misc queries) | |||
| how can I duplicate or copy a workbook then divide selected cells. | Excel Discussion (Misc queries) | |||
Linear Mode
