How do I stop the statistics that I enter from turning into dates?

How do I stop the statistics that I enter from turning into dates? I'm trying to keep records like 12-4-1 and it will turn it into 12/4/2001

MacBook Pro 13″, macOS 11.6

Posted on Oct 18, 2022 11:54 PM

Reply
Question marked as Top-ranking reply

Posted on Oct 19, 2022 02:59 AM

You have two options:


A: Format the cell as TEXT, then Numbers will not "try to help you" by changing it in date


B: Just write '12-4-1 then Numbers knows that you want a Text.


Ralf

1 reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How do I stop the statistics that I enter from turning into dates?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.