Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

@oon_027 - You also might consider to delete the ambiguous and error-prone "date recognition pattern" M-D (or was it D-M ?) from 'Tools' > 'Options...' > Language Settings' > 'Languages' > Last field in the first segment.

Another hint: The reason for using a Calc (spreadsheet) document in such a case and preferring it compared to a table inserted into a text document (or simply text justified by tab) might be the intention to do some evaluation by calculations. If one has this in mind he (f/m) should consider NOT to enter the result as a whole including any delimiter BUT entering the scores for the two teams separately in two cells (between which there my be a third one containing the proper symbol).

@oon_027 - You also might consider to delete the ambiguous and error-prone "date recognition pattern" M-D (or was it D-M ?) from 'Tools' > 'Options...' > Language Settings' > 'Languages' > Last field in the first segment.

Another hint: The reason for using a Calc (spreadsheet) document in such a case and preferring it compared to a table inserted into a text document (or simply text justified by tab) might be the intention to do some evaluation by calculations. If one has this in mind he (f/m) should consider NOT to enter the result as a whole including any delimiter BUT entering the scores for the two teams separately in two cells (between which there my may be a third one containing the proper symbol).

@oon_027 @con_027 - You also might consider to delete the ambiguous and error-prone "date recognition pattern" M-D (or was it D-M ?) from 'Tools' > 'Options...' > Language Settings' > 'Languages' > Last field in the first segment.

Another hint: The reason for using a Calc (spreadsheet) document in such a case and preferring it compared to a table inserted into a text document (or simply text justified by tab) might be the intention to do some evaluation by calculations. If one has this in mind he (f/m) should consider NOT to enter the result as a whole including any delimiter BUT entering the scores for the two teams separately in two cells (between which there may be a third one containing the proper symbol).

@con_027 - You also might consider to delete the ambiguous and error-prone "date recognition pattern" M-D (or was it D-M ?) from 'Tools' > 'Options...' > Language Settings' > 'Languages' > Last field in the first segment.

Another hint: The reason for using a Calc (spreadsheet) document in such a case and preferring it compared to a table inserted into a text document (or simply text justified by tab) might be the intention to do some evaluation by calculations. If one has this in mind he (f/m) should consider NOT to enter the result as a whole including any delimiter BUT entering the scores for the two teams separately in two cells (between which there may be a third one containing the proper symbol).

[begin EDIT]

@con_27 - Tell us about your further experiences, please. Did you try what I suggested in my comment to the other answer? [end EDIT]

@con_027 - You also might consider to delete the ambiguous and error-prone "date recognition pattern" M-D (or was it D-M ?) from 'Tools' > 'Options...' > Language Settings' > 'Languages' > Last field in the first segment.

Another hint: The reason for using a Calc (spreadsheet) document in such a case and preferring it compared to a table inserted into a text document (or simply text justified by tab) might be the intention to do some evaluation by calculations. If one has this in mind he (f/m) should consider NOT to enter the result as a whole including any delimiter BUT entering the scores for the two teams separately in two cells (between which there may be a third one containing the proper symbol).

[begin EDIT]

begin EDIT @con_27 - Tell us about your further experiences, please. Did you try what I suggested in my comment to the other answer? answer? [end EDIT]

[begin EDIT2]Very sorry! I acted like an idiot. You won't be able to remove an annoying "recognition pattern M-D" from the settings because this never was there. It is taken as an abbreviated calendar date of the current year on the base of the 'ISO 8601' format. I'm afraid that cannot be switched off. Down with all silly smart features! The only way will be to choose the so called number format "@" for the cells concerned in advance. (It isn't really a number format and it has disadvantages.) But I cannot think of ANY reason for what that might not work. [end EDIT2]

@con_027 - You also might consider to delete the ambiguous and error-prone "date recognition pattern" M-D (or was it D-M ?) from 'Tools' > 'Options...' > Language Settings' > 'Languages' > Last field in the first segment.

Another hint: The reason for using a Calc (spreadsheet) document in such a case and preferring it compared to a table inserted into a text document (or simply text justified by tab) might be the intention to do some evaluation by calculations. If one has this in mind he (f/m) should consider NOT to enter the result as a whole including any delimiter BUT entering the scores for the two teams separately in two cells (between which there may be a third one containing the proper symbol).

begin EDIT [begin EDIT] (withdrawn) @con_27 - Tell us about your further experiences, please. Did you try what I suggested in my comment to the other answer? [end EDIT]

[begin EDIT2]Very sorry! I acted like an idiot. You won't be able to remove an annoying "recognition pattern M-D" from the settings because this never was there. It is taken as an abbreviated calendar date of the current year on the base of the 'ISO 8601' format. I'm afraid that cannot be switched off. Down with all silly smart features! The only way will be to choose the so called number format "@" for the cells concerned in advance. (It isn't really a number format and it has disadvantages.) But I cannot think of ANY reason for what that might not work. [end EDIT2]

@con_027 - You also might consider to delete the ambiguous and error-prone "date recognition pattern" M-D (or was it D-M ?) from 'Tools' > 'Options...' > Language Settings' > 'Languages' > Last field in the first segment.

Another hint: The reason for using a Calc (spreadsheet) document in such a case and preferring it compared to a table inserted into a text document (or simply text justified by tab) might be the intention to do some evaluation by calculations. If one has this in mind he (f/m) should consider NOT to enter the result as a whole including any delimiter BUT entering the scores for the two teams separately in two cells (between which there may be a third one containing the proper symbol).

[begin EDIT] (withdrawn) @con_27 - Tell us about your further experiences, please. Did you try what I suggested in my comment to the other answer? [end EDIT]

[begin EDIT2]Very sorry! I acted like an idiot. You won't be able to remove an annoying "recognition pattern M-D" from the settings because this never was there. It is taken Taking this as an abbreviated calendar date of the current year on the base of the 'ISO 8601' format. I'm afraid that this will be locale independent and cannot be switched off. Down with all silly smart features! The only way will be to choose the so called number format "@" for the cells concerned in advance. (It isn't really a number format and it has disadvantages.) But I cannot think of ANY reason for what that might not work. I want to uphold my other suggestion (separate cells). [end EDIT2]

[ Withdrawn: @con_027 - You also might consider to delete the ambiguous and error-prone "date recognition pattern" M-D (or was it D-M ?) from 'Tools' > 'Options...' > Language Settings' > 'Languages' > Last field in the first segment.segment. ]

Another hint: The reason for using a Calc (spreadsheet) document in such a case and preferring it compared to a table inserted into a text document (or simply text justified by tab) might be the intention to do some evaluation by calculations. If one has this in mind he (f/m) should consider NOT to enter the result as a whole including any delimiter BUT entering the scores for the two teams separately in two cells (between which there may be a third one containing the proper symbol).

[begin EDIT] (withdrawn) (Withdrawn) @con_27 - Tell us about your further experiences, please. Did you try what I suggested in my comment to the other answer? [end EDIT]

[begin EDIT2]Very sorry! I acted like an idiot. You won't be able to remove an annoying "recognition pattern M-D" from the settings because this never was there. Taking this as an abbreviated calendar date of the current year on the base of the 'ISO 8601' format. I'm afraid this will be locale independent and cannot be switched off. Down with all silly smart features! The only way will be to choose the so called number format "@" for the cells concerned in advance. (It isn't really a number format and it has disadvantages.) But I cannot think of ANY reason for what that might not work. I want to uphold my other suggestion (separate cells). [end EDIT2]

[ Withdrawn: @con_027 - You also might consider to delete the ambiguous and error-prone "date recognition pattern" M-D (or was it D-M ?) from 'Tools' > 'Options...' > Language Settings' > 'Languages' > Last field in the first segment. ]

Another hint: The reason for using a Calc (spreadsheet) document in such a case and preferring it compared to a table inserted into a text document (or simply text justified by tab) might be the intention to do some evaluation by calculations. If one has this in mind he (f/m) should consider NOT to enter the result as a whole including any delimiter BUT entering the scores for the two teams separately in two cells (between which there may be a third one containing the proper symbol).

[begin EDIT] (Withdrawn) @con_27 - Tell us about your further experiences, please. Did you try what I suggested in my comment to the other answer? [end EDIT]

[begin EDIT2]Very sorry! EDIT2]Very sorry! I acted like an idiot. You won't be able to remove an annoying "recognition pattern M-D" from the settings because this never was there. Taking this as an abbreviated calendar date of the current year on the base of the 'ISO 8601' format. I'm afraid this will be locale independent and cannot be switched off. Down with all silly smart features! The only way will be to choose the so called number format "@" for the cells concerned in advance. (It isn't really a number format and it has disadvantages.) But I cannot think of ANY reason for what that might not work. I want to uphold my other suggestion (separate cells). [end EDIT2]