Convert numerical data in a spreadsheet
 

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

Convert numerical data in a spreadsheet
 

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
clickPaste specialclick the radio button values onlyOk.
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


"Stefan" wrote:

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

Convert numerical data in a spreadsheet
 

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

Regards,
Fred.

"Stefan" wrote in message
...
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