Forum Discussion

Jacobs1's avatar
Jacobs1
Copper Contributor
Feb 03, 2026

Excel keeps changing “January 2026” into “JAN-26”. How can I force it to display “January 2026”?

 

1 Reply

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor

    Format the cell(s) where you want to enter January 2026 and the like as Text then enter January 2026...

    Other way, precede January 2026 with an apostrophe: 'January 2026

Resources