Convert numerical data in a spreadsheet

[Stefan]

Hi,

I´ve a spreadsheet with a lot of numerical data (data is printed by hand).
I´m looking for a way to use a formula in the spreadsheet (without
creating a
new sheet or changning any values in the spreadsheet) that will divide all
data with 5.

I´m looking for both macro-solution and preferdaly a solution without
macro.

Regards
Stefan

 

[Suleman Peerzade]

Hi,

Say your data is in cell A1 and down, for eg a number is there (500) and you
want this number to be divided by 5. In cell B1 put =A1/5 and copy down till
the end. Now you have the result in column B copy them and in cell A1 right
click>>Paste special>>click the radio button values only>>Ok.
This will paste the result of col B in col A.

Hope i have given the right answer.
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade

 

[Fred Smith]

You don't even need a formula. Enter 5 in an unused cell. Copy it. Highlight
your numerical data, right-click, choose Paste Special...>Divide>OK

Regards,
Fred.