Sorry. I want to clarify....
--put 100 in any blank cell and then copy that cell
--select all your cells that you want to divide by 100
--hit Edit--Paste special, Divide, OK.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"chrismiclei"
wrote in message
...

I am trying to divide a column that just contains numbers by 100, but I
read online that I should use some paste special technique, but my
version of excel doesn't have that. I think I have '97. Is there
another method to divide every cell in a column by 100?


--
chrismiclei
------------------------------------------------------------------------
chrismiclei's Profile:
http://www.excelforum.com/member.php...o&userid=25055
View this thread: http://www.excelforum.com/showthread...hreadid=385777