Convert numerical data

  • Thread starter Thread starter Stefan
  • Start date Start date
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
 
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.
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert numerical data in a spreadsheet 2
Transfer field data from a main & sub form 2
Link Access to Excel export back to excel 3
How to convert a .msg File? 2
Form Print Screen button 1
Help With Sorting Alphanumeric Data 3
Multiple Tables; Identical Format Slightly Different Data 12
Encrpytion routine - embedded nulls in BSTR 4

Back
Top