If you mean you have, say 150,000 (in Cell A1)
In a blank cell (somewhere/anywhere) enter 1,000

Then select the cell with the 1,000 value and Ctrl+C
(To Copy it)..

Move your cursor and Click on A1, then at the Menu,
Go to Edit, Paste-Special..., In the Dialog Box under Operation - click on
the DIVIDE (radio button) and OK.

Erase the content of the cell that you originally entered
the 1,000




"jcastellano"
wrote in message
...

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