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
---