applying operation to column

[chrismiclei]

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

 

[Anne Troy]

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" <[email protected]>
wrote in message
news:[email protected]...

 

[Anne Troy]

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" <[email protected]>
wrote in message
news:[email protected]...