ExcelBanter - Date Auto-Correction

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Date Auto-Correction (https://www.excelbanter.com/excel-discussion-misc-queries/131166-date-auto-correction.html)

Mozman

Date Auto-Correction

When I type '1-5' as a football scoreline, it chnages it to 01-May, I do not
want this to happen, how do I turn off this auto-correction so it never
happens again?

JE McGimpsey

Date Auto-Correction

You can't change the input parser's behavior, but you can bypass it by
either (a) prefixing the entry with an apostrophie ('), or (b)
preformatting the cell as Text so that it isn't parsed.

In article ,
Mozman wrote:

When I type '1-5' as a football scoreline, it chnages it to 01-May, I do not
want this to happen, how do I turn off this auto-correction so it never
happens again?

John

Date Auto-Correction

Type an apostrophe and then the score('1-5) or format the cells to text
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

"Mozman" wrote:

When I type '1-5' as a football scoreline, it chnages it to 01-May, I do not
want this to happen, how do I turn off this auto-correction so it never
happens again?

Teethless mama

Date Auto-Correction

one way...
press a space bar then type 1-5

"Mozman" wrote:

When I type '1-5' as a football scoreline, it chnages it to 01-May, I do not
want this to happen, how do I turn off this auto-correction so it never
happens again?

All times are GMT +1. The time now is 03:03 AM.