Forum Discussion
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?
But what do you want to see then?
- I want to see --> 22,3355
I do not want that Excel modifies what I typed
- It seems Excel interprets as you are typing a large number instead of small with four decimals.
Your local settings have period to mark thousands..?!
What is decimal character?. You can see it eg by typing =3/2 in a cell.
If you want it exactly as typed and not interpreted as something to posiibly use for calcalations, begin with an ' to comment the content and show like text.- 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?- insert = first to get a calculation resulting 1,5
