Change data from one cell to another cell

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

Guest

How can I automatically change data entered in cell A1 (32454521) into a
dollar amount in cell A2 ($16.25)? Thanks for your guidance!
 
Since you don't give much detail, my GUESS is that this is some part number
and you want to lookup the price. If so, look in the help index for VLOOKUP
 
Is this the only forum where part of the puzzle
is actually trying to work out what the question really is :)
 
In A2 enter =A1/1997201.292

Format as Currency


Gord Dibben MS Excel MVP
 
SteveW,
Nope! I regularly visit about 12 of these newsgroups, it happens everywhere.
Most individuals could find the answer with the F1 key, IF they knew what
the question was.
 
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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Not sure of formula help please 4
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
excel formula 1
View lengthy text from one cell to another cell without widening c 1
Excel JUMP FROM SEARCH BAR TO RESULT 3
Excel formula, sum the value cell and if empty cell left blank 0
Month Formula 3

Back
Top