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

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"tmitchell" <(E-Mail Removed)> wrote in message
news:4F90AD88-3124-412F-89C9-(E-Mail Removed)...
> How can I automatically change data entered in cell A1 (32454521) into a
> dollar amount in cell A2 ($16.25)? Thanks for your guidance!

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
<(E-Mail Removed)> 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)

In A2 enter =A1/1997201.292

Format as Currency


Gord Dibben MS Excel MVP

On Wed, 5 Jul 2006 07:34:03 -0700, tmitchell
<(E-Mail Removed)> 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!

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" <(E-Mail Removed)> wrote in message
newsp.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
> <(E-Mail Removed)> 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)