Forum Discussion
Solved
Excel does not take correct number
I open a new Excel an type in 22,3355 After pressing enter 223.355 will appear in the cell. What can I do to prevent this?
What is the decimal separator on your system?
What is the thousands separator on your system?
Thanks for your note. I type in 3/2
And I get this --> 03. Feb
There must be something in the local settings. Do you know what I have to adjust?
And I get this --> 03. Feb
There must be something in the local settings. Do you know what I have to adjust?
insert = first to get a calculation resulting 1,5
- if I type in 1,5 -->then in the cell I see 1,5 and this is ok, I can use it to calculate
if I type in 1,55 -->then in the cell I see 1,55 and this is ok, I can use it to calculate
if I type in 1,555 -->then in the cell I see 1,555 but it is not a number, I cannot use it to calculate- I inserted =3/2
the result in the cell is 1.5What is the decimal separator on your system?
What is the thousands separator on your system?