number with decimal

  • Thread starter Thread starter Marco Cecchi
  • Start date Start date
M

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
 
Marco Cecchi said:
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
Click to expand...

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.
 
Back
Top