[Solved] Numbers as is

hnl · Post by **hnl** » Thu Jun 26, 2008 10:08 pm

Is where a way to show numbers without formatting? So something like
10 0.0501
do not become
10 0.05
or
10.0000 0.0501

edit this topic's initial post · Post by **Villeroy** » Thu Jun 26, 2008 10:14 pm

Remove the formatting (number format "General"). How do you get this strange format "10.0000 0.0501" and what number does it represent? Are you using some Asian locale?

hnl · Post by **hnl** » Fri Jun 27, 2008 6:13 am

No such formatting. Only "Standard". Which doesn't change anything.
>How do you get this strange format "10.0000 0.0501" and what number does it represent?
This is 2 numbers. With increased fraction nulls.

Nikos · Post by **Nikos** » Fri Jun 27, 2008 10:07 am

How about something like that:
0,###########

The decimals are in this case only shown if they exist.

(OO2.4.1 W2K, OO2.4.1.5 (Novell edition) OpenSuse 10.3, OO2.4.1 Xubuntu 8.04)

edit this topic's initial post · Post by **Villeroy** » Fri Jun 27, 2008 11:59 am

Are you shure your values are numbers at all?
A1: 10.0000
A2: 0.0501
B1: =ISNUMBER(A1)
B2: =ISNUMBER(A2)
or =COUNT($A$1:$A$2) to counts numbers in A1:A2.
or =SUM($A$1:$A$2) which does not yield 10.0501 if A1 and B1 are not both numeric.

hnl · Post by **hnl** » Fri Jun 27, 2008 4:44 pm

>>How about something like that:
>>0,###########
thanx

[Solved] Numbers as is

[Solved] Numbers as is

Re: numbers as is

Re: numbers as is

Re: numbers as is

Re: numbers as is

Re: numbers as is