Formatting a decimal representation of millions "stunnie" <stunnie[ at ]yahoo.com> 19.09.2006 12:49:50 Hi, How can I format a number in a cell such as 0.55 (the cell heading is $ millions in another cell to read $550K? Is this possible? Thanks, s

Re: Formatting a decimal representation of millions Dave Peterson <petersod[ at ]verizonXSPAM.net> 19.09.2006 13:03:53 This will return text: =TEXT(A1*1000000,"$0,")&"K" This will return a value (in millions): =A1*1000000 but give it a custom format of: $0,K (Format|cells|number tab|custom category) stunnie wrote: [Quoted Text] > > Hi, > > How can I format a number in a cell such as 0.55 (the cell heading is $ > millions in another cell to read $550K? Is this possible? > > Thanks, > > s -- Dave Peterson

Re: Formatting a decimal representation of millions "Bob Phillips" <bob.NGs[ at ]somewhere.com> 19.09.2006 14:57:30 =TEXT(A1*1000,"$0\K") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "stunnie" <stunnie[ at ]yahoo.com> wrote in message news:1158670190.058610.308110[ at ]i3g2000cwc.googlegroups.com... [Quoted Text] > Hi, > > How can I format a number in a cell such as 0.55 (the cell heading is $ > millions in another cell to read $550K? Is this possible? > > Thanks, > > s >

Re: Formatting a decimal representation of millions Dave Peterson <petersod[ at ]verizonXSPAM.net> 19.09.2006 16:40:52 Hmmm. I guess that multiplying by a million and dividing by 1000 isn't time well spent???? But even shorter: =TEXT(A1*1000,"$0K") <gd&r> Bob Phillips wrote: [Quoted Text] > > =TEXT(A1*1000,"$0\K") > > -- > HTH > > Bob Phillips > > (replace somewhere in email address with gmail if mailing direct) > > "stunnie" <stunnie[ at ]yahoo.com> wrote in message > news:1158670190.058610.308110[ at ]i3g2000cwc.googlegroups.com... > > Hi, > > > > How can I format a number in a cell such as 0.55 (the cell heading is $ > > millions in another cell to read $550K? Is this possible? > > > > Thanks, > > > > s > > -- Dave Peterson