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!
dollar amount in cell A2 ($16.25)? Thanks for your guidance!
D
Don Guillett
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
and you want to lookup the price. If so, look in the help index for VLOOKUP
S
SteveW
Is this the only forum where part of the puzzle
is actually trying to work out what the question really is
is actually trying to work out what the question really is
G
Gord Dibben
In A2 enter =A1/1997201.292
Format as Currency
Gord Dibben MS Excel MVP
Format as Currency
Gord Dibben MS Excel MVP
C
Chuck Davis
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.
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.