Change data from one cell to another cell tmitchell 05.07.2006 14:34:03 How can I automatically change data entered in cell A1 (32454521) into a dollar amount in cell A2 ($16.25)? Thanks for your guidance!

Re: Change data from one cell to another cell "Don Guillett" <dguillett1[ at ]austin.rr.com> 05.07.2006 14:46:34 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 dguillett1[ at ]austin.rr.com "tmitchell" <tmitchell[ at ]discussions.microsoft.com> wrote in message news:4F90AD88-3124-412F-89C9-B593198E80C3[ at ]microsoft.com... [Quoted Text] > How can I automatically change data entered in cell A1 (32454521) into a > dollar amount in cell A2 ($16.25)? Thanks for your guidance!

Re: Change data from one cell to another cell SteveW <sj_walton[ at ]nothotmail.com> 05.07.2006 15:06:33 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 <dguillett1[ at ]austin.rr.com> wrote: [Quoted Text] > 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)

Re: Change data from one cell to another cell Gord Dibben <gorddibbATshawDOTca> 05.07.2006 19:30:52 In A2 enter =A1/1997201.292 Format as Currency Gord Dibben MS Excel MVP On Wed, 5 Jul 2006 07:34:03 -0700, tmitchell <tmitchell[ at ]discussions.microsoft.com> wrote: [Quoted Text] >How can I automatically change data entered in cell A1 (32454521) into a >dollar amount in cell A2 ($16.25)? Thanks for your guidance!

Re: Change data from one cell to another cell "Chuck Davis" <newsgroup at anthemwebs dot com> 06.07.2006 00:16:29 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" <sj_walton[ at ]nothotmail.com> wrote in message news:op.tb71k9rwevjsnp[ at ]enigma03... [Quoted Text] > 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 > <dguillett1[ at ]austin.rr.com> 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)