just type 1000 (or whatever you need to do your conversion) en any cell, copy
it, open edit/paste special, and select divide or whatever funcion you like.

I frequently use it to multiply by -1, changing negatives to positives.......
You can also use it to convert numbers in Text format to number format by
multiplying by 1.

"jcastellano" wrote:


I am trying to convert whole numbers in a spreadsheet to thousands. I
was told there was a way to use the Paste Special Divide feature? Any
thoughts?


--
jcastellano
------------------------------------------------------------------------
jcastellano's Profile: http://www.excelforum.com/member.php...o&userid=30986
View this thread: http://www.excelforum.com/showthread...hreadid=519878