Hello all!
In Germany, we use the comma as the decimal separator. So far, so good.
In a spreadsheet for production material, I now want to number the items, in the form:
1
1.1
1.2
etc.
If I define "Text" as cell format, then in a cell in which I enter a number, this green triangle appears, because Excel thinks it knows better than I what that cell format should be.
When users then click on "convert to a number", the pivot evaluation based on this table gets messed up because it interprets numbers differently than text.
How can I solve this problem without the users getting
Thanks for tips!
In Germany, we use the comma as the decimal separator. So far, so good.
In a spreadsheet for production material, I now want to number the items, in the form:
1
1.1
1.2
etc.
If I define "Text" as cell format, then in a cell in which I enter a number, this green triangle appears, because Excel thinks it knows better than I what that cell format should be.
When users then click on "convert to a number", the pivot evaluation based on this table gets messed up because it interprets numbers differently than text.
How can I solve this problem without the users getting
- have to prepend an apostrophe?
- have a way to change the cell format?
- no error notice appears in the form of a green triangle?
Thanks for tips!