| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding data to celss but keeping the remaining data intact.
Hi,
Can anyone help me, I have a financial workbook which is all in millions i.e 1.1 this data should actually be in 000's i.e. 1100 There are several fourmulas in this workbook and these need to remain intact so is there any way of multiplying every selected cell by 1000 whilst keeping the remaining formulas/data untouched? Any help would be most appreciated |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding data to celss but keeping the remaining data intact.
One method is to 'copy' and 'past special' (select the Multiply option) 1000
to all the selected cells, but you will need to ensure that the cells containing formula are not selected. To do this type '1000' into an empty cell. Right click the cell and select Copy. Then highlight all the cells containing data. Right click and select 'Paste Special', choose the Multiply option and click OK. The job should be done! If this would be very difficult, consider copying your equations to a different sheet and then copying them back on completion of the multiply paste. Hope this helps. -- Peter "TP" wrote: Hi, Can anyone help me, I have a financial workbook which is all in millions i.e 1.1 this data should actually be in 000's i.e. 1100 There are several fourmulas in this workbook and these need to remain intact so is there any way of multiplying every selected cell by 1000 whilst keeping the remaining formulas/data untouched? Any help would be most appreciated |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding data to celss but keeping the remaining data intact.
Just to add on a little ..
If its only numbers on the sheet that needs to be multiplied by 1000, the selection of these data cells all over the sheet for the paste special multiply operation (after copying the cell with 1000 in it) could be eased via: Press F5 Special Check "Constants" Then uncheck: Text, Logicals, Errors Click OK -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding data to celss but keeping the remaining data intact.
Max,
Many thanks for that - a useful trick! Regards, -- Peter "Max" wrote: Just to add on a little .. If its only numbers on the sheet that needs to be multiplied by 1000, the selection of these data cells all over the sheet for the paste special multiply operation (after copying the cell with 1000 in it) could be eased via: Press F5 Special Check "Constants" Then uncheck: Text, Logicals, Errors Click OK -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding data to celss but keeping the remaining data intact.
"Peter" wrote:
Many thanks for that - a useful trick! Delighted, Peter! I've found the "Go To Special" dialog (accessed via: F5, Ctrl+G, or Edit Go To) useful in providing a number of options to quickly select cells -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| How do I create a rolling average chart, adding most recent data? | Charts and Charting in Excel | |||
| Help with data not getting plotted | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
Linear Mode
