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: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" <Greg(a)discussions.microsoft.com> 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" <Greg(a)discussions.microsoft.com> 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


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