ExcelBanter - applying operation to column

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - applying operation to column (https://www.excelbanter.com/excel-discussion-misc-queries/34509-applying-operation-column.html)

chrismiclei

applying operation to column

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

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"
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

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"
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

All times are GMT +1. The time now is 04:56 AM.