Perfect, that's exactly what I was looking for.

Thanks

"daddylonglegs" wrote:


Yes, there is an option to do that.

Put 1000 in an empty cell and copy that cell then select the range of
cells you wish to multiply by 1000 and use Edit Paste Special
Multiply


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=511568