number with decimal

[Marco Cecchi]

only the number with a .4 decimal (ex. 102.4 or NNN.4)are
visualized in a wrong mode (visualized on left).
All the column are setting in the same mode.

Ex.:
12.1
13.3
12.4 this number is visulized on the left
16.6
12.41

Marco

 

[Anon]

only the number with a .4 decimal (ex. 102.4 or NNN.4)are
visualized in a wrong mode (visualized on left).
All the column are setting in the same mode.

Ex.:
12.1
13.3
12.4 this number is visulized on the left
16.6
12.41

Marco

Most probably it has somehow been entered as text. Make sure the cell is now
formatted like the others; you can use the format painter to do this. Then
select the cell, click in the formula bar and press ENTER.