Convert numerical data

S

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
 
D

Douglas J. Steele

This newsgroup is for questions about Access, the database product that's
part of Office Professional.

It would appear that you're dealing with Excel. You'd be best off reposting
your question to a newsgroup related to Excel.
 
B

BruceM

This is a newsgroup for Microsoft Access, a relational databse program. You
would do best to ask in an Excel group. That said, could you just use the
formula =A5/5 in a new column, where A5 is the cell with the data that is to
be divided by 5?
 
Top