Change data from one cell to another cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tmitchell - 05 Jul 2006 15:34 GMT

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

Reply to this Message

Don Guillett - 05 Jul 2006 15:46 GMT

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

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

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

Reply to this Message

SteveW - 05 Jul 2006 16:06 GMT

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

> 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

Signature

Steve (3)

Reply to this Message

Chuck Davis - 06 Jul 2006 01:16 GMT

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.

> Is this the only forum where part of the puzzle
> is actually trying to work out what the question really is :)
[quoted text clipped - 3 lines]
>> and you want to lookup the price. If so, look in the help index for
>> VLOOKUP

Reply to this Message

Gord Dibben - 05 Jul 2006 20:30 GMT

In A2 enter =A1/1997201.292

Format as Currency

Gord Dibben MS Excel MVP

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

Reply to this Message