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" wrote in message news:4EF39C56-C572-4F10-8D37-00C29AA3650C(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" wrote in message > news:4EF39C56-C572-4F10-8D37-00C29AA3650C(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" wrote in message news:4EF39C56-C572-4F10-8D37-00C29AA3650C(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  |