using the same function to convert a column of numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column of numbers (one currency) that I need to convert into a new
column of numbers (another currency). I.e. how do I convert each cell in
column G1-G5 to new numbers H1-H5 where each of the G cells have been divided
by 7.5?
 
H1: =G1/7.5

and copy down to G5

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

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

how to apply one function to an entire column of numbers 1
Set add function ignore #N/A 1
I type in a number in a cell but it wont convert to currency help 2
Excel Numbering rows by font color, but skipping blanks 1
adding every other column 7
deleting numbers in a column 2
Countif/SumProduct 4
Convert number to text as displayed 3

Back
Top