From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Avoid unintentional entries when typing code numbers

Avoid unintentional entries when typing code numbers - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Avoid unintentional entries when typing code numbers

- [Narrator] When you type certain kinds of numbers, 2 perhaps a code number, product number, 3 part number, an ID number. 4 If they look something like 5 what we're seeing in this green box, 6 you might get some unintended entries. 7 I'm going to type one MAR. 8 Now whether I type upper or lowercase, 9 C six seven, just the way we see it 10 in that first entry, I press enter. 11 I'm a little bit surprised. 12 What do we see here? 13 Excel reads that as March 1st, 1967. 14 How about the next one? 15 NOVE seven, whether we use 16 upper lowercase, makes no difference, but here too. 17 Because we have a partial spelling of a month, 18 Excel reads that as if it were a date. 19 November seventh, 2018 is the current year, and so on. 20 So the first four of these, 21 what they all have in common is you'll see at least 22 three letters of a month here. 23 Now it might be four letters, it could be five or six. 24 Same thing…

Contents