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