Yes, you have the paste special, but you first have to copy a cell that
contains 100 in it. Then, 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