| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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) |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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) |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| How do I change a cell so I can have the data it contains in seve. | Excel Discussion (Misc queries) | |||
Hybrid Mode
