| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Copy one cell to entire column | Excel Discussion (Misc queries) | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| Formula for a column | Excel Discussion (Misc queries) | |||
| Auto Skipping and protected cells | Excel Discussion (Misc queries) | |||
Linear Mode
