Changing entire column data

I have a quick question for anyone who can help. I have a large data set that
I need to convert. To explain this I have three columns with 450 data points
in each. In one of the columns I need to change each data entry by the same
amount. (x+25)/25. I am wondering if there is a way to have excel change each
point by that amount, rather than doing it by hand.
-Thanks in advance for the help

1. Key 25 and 1 in 2 open cells.
2. Copy the cell with 25.
3. Select the range of data to update
4. Go to Edit > Paste Special. Select "Divide". OK
2. Copy the cell with 1.
3. Select the range of data to update
4. Go to Edit > Paste Special. Select "Add". OK

HTH
Jason
Atlanta, GA

>-----Original Message-----
>I have a quick question for anyone who can help. I have
a large data set that
>I need to convert. To explain this I have three columns
with 450 data points
>in each. In one of the columns I need to change each
data entry by the same
>amount. (x+25)/25. I am wondering if there is a way to
have excel change each
>point by that amount, rather than doing it by hand.
>-Thanks in advance for the help
>.
>