EXCEL HOW TO ADD 100 to all my values in a column
 

I rarely use excel, but from time to time i have to create certain reports, i
have
column G with 50 numbers, and i would like multiply each number by 100. I
dont want to go one by one, please help me out, thank you..have a nice day...

EXCEL HOW TO ADD 100 to all my values in a column
 

put 100 in a cell somewherecopy that cellselect your columneditpaste
specialmultiply

--
Don Guillett
SalesAid Software

"drhell" wrote in message
...
I rarely use excel, but from time to time i have to create certain reports,
i
have
column G with 50 numbers, and i would like multiply each number by 100. I
dont want to go one by one, please help me out, thank you..have a nice
day...

EXCEL HOW TO ADD 100 to all my values in a column
 

In an us-used cell, enter 100 anc opy that cell.

Select your column of cells and:

Edit PasteSpecial and check the multiply box
This will multiply each of the munbers by 100.


To add 100 to each number, check the Add box instead.
--
Gary's Student
gsnu200701


"drhell" wrote:

I rarely use excel, but from time to time i have to create certain reports, i
have
column G with 50 numbers, and i would like multiply each number by 100. I
dont want to go one by one, please help me out, thank you..have a nice day...