Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |