Change data from one cell to another cell
 

How can I automatically change data entered in cell A1 (32454521) into a
dollar amount in cell A2 ($16.25)? Thanks for your guidance!

Change data from one cell to another cell
 

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

--
Don Guillett
SalesAid Software

"tmitchell" wrote in message
...
How can I automatically change data entered in cell A1 (32454521) into a
dollar amount in cell A2 ($16.25)? Thanks for your guidance!

Change data from one cell to another cell
 

Is this the only forum where part of the puzzle
is actually trying to work out what the question really is :)

On Wed, 05 Jul 2006 15:46:34 +0100, Don Guillett
wrote:

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




--
Steve (3)

Change data from one cell to another cell
 

In A2 enter =A1/1997201.292

Format as Currency


Gord Dibben MS Excel MVP

On Wed, 5 Jul 2006 07:34:03 -0700, tmitchell
wrote:

How can I automatically change data entered in cell A1 (32454521) into a
dollar amount in cell A2 ($16.25)? Thanks for your guidance!

Change data from one cell to another cell
 

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.
"SteveW" wrote in message
news:op.tb71k9rwevjsnp@enigma03...
Is this the only forum where part of the puzzle
is actually trying to work out what the question really is :)

On Wed, 05 Jul 2006 15:46:34 +0100, Don Guillett
wrote:

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




--
Steve (3)