Forum Discussion
Tjin
Jan 22, 2025Copper Contributor
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...
HansVogelaar
Jan 22, 2025MVP
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.
- TjinJan 23, 2025Copper Contributor
Thank you. I guess I'll just change it to text then.