Forum Discussion
Can we prevent Excel from auto-appending year?
Would appreciate it if someone could help me with this little problem: I have a spreadsheet where I do reconciliation of monthly sales, and I usually key in the dates as dd-yyy. Eg, for a payment...
A 'real' date in Excel must have a year. If it's just for display purposes you can either format the cell as text before entering a value such as 15-Jan, or prefix the value with an apostrophe: '15-Jan. The apostrophe forces Excel to treat the value as text. It will be displayed in the formula bar but not in the cell itself.
Thank you. I guess I'll just change it to text then.