How can I automatically change data entered in cell A1 (32454521) into a
dollar amount in cell A2 ($16.25)? Thanks for your guidance!
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
[email protected]
"tmitchell" <[email protected]> wrote in message
news:[email protected]...
> 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
<[email protected]> 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
<[email protected]> 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" <[email protected]> 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
> <[email protected]> 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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks