Prev: summing total sales formula
Next: Symbols on the keyboard are not the symbols on the screen....
From: Greg on 21 May 2010 13:30 hi, is that possible to format the numbers w/o % sign, i.e, the number .4 would appear as 40 and not as 40%? Thanks  ______ Regards, Greg
From: Luke M on 21 May 2010 14:46 Without the symbol, wouldn't that be confusing/deceptive? An alternative would be to use fixed decimal when inputting the number (Tools  Options  Edit) or to have a helper cell multiply by 10.  Best Regards, Luke M "Greg" <Greg(a)discussions.microsoft.com> wrote in message news:4EF39C56C5724F108D3700C29AA3650C(a)microsoft.com... > hi, > > is that possible to format the numbers w/o % sign, i.e, the number .4 > would appear as 40 and not as 40%? > > Thanks > >  > ______ > Regards, > Greg
From: Greg on 21 May 2010 15:39 I agree, but that's not my call unfortunately. Applying fixed decimal does not work  it converts 200 into 2, when using 2 places. again, i need a per cent to appear as it multiplied by 100. so the cell value contains: 0.4 and looks like 40. "Luke M" wrote: > Without the symbol, wouldn't that be confusing/deceptive? > An alternative would be to use fixed decimal when inputting the number > (Tools  Options  Edit) or to have a helper cell multiply by 10. > >  > Best Regards, > > Luke M > "Greg" <Greg(a)discussions.microsoft.com> wrote in message > news:4EF39C56C5724F108D3700C29AA3650C(a)microsoft.com... > > hi, > > > > is that possible to format the numbers w/o % sign, i.e, the number .4 > > would appear as 40 and not as 40%? > > > > Thanks > > > >  > > ______ > > Regards, > > Greg > > > . >
From: "David Biddulph" groups [at] on 23 May 2010 06:26 Multiply by 100. You can't do it by formatting, as 40 is not the same number as 0.4.  David Biddulph "Greg" <Greg(a)discussions.microsoft.com> wrote in message news:4EF39C56C5724F108D3700C29AA3650C(a)microsoft.com... > hi, > > is that possible to format the numbers w/o % sign, i.e, the number .4 > would appear as 40 and not as 40%? > > Thanks > >  > ______ > Regards, > Greg

Pages: 1 Prev: summing total sales formula Next: Symbols on the keyboard are not the symbols on the screen.... 