Forum Discussion
Naming cells goes wrong!
I have a file recording magazine issues. Each block of 12 (1per year) contains the year number (such as 1992) in column1 (General format - changing it to Date format won't work, and changing it to N...
Excel automatically converts texts like Jan92 into the dates (Jan 01, 1992 - you may check in formula bar). In general it is always to work with dates using desired format for them (e.g. "mmmyy").
If you still prefer texts instead of dates you may apply Text format to the cells before you add values into them; or enter texts with single apostrophe in front like 'Jan92, such texts wont be converted and apostrophe won't be visible.