You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Trafficlaw Author

Level 1

27 points

writing numbers in Numbers

I am trying to write 3/467 in Numbers. It always automatically changes this to 3/67, which seems to be a date.

I have tried to find a setting that will allow me to keep the text I type and not change it, but I can not find any way to stop this "feature" stuffing up my work.

Any ideas?

MacBook Pro 13″, macOS 10.13

Posted on Jul 31, 2022 7:00 AM

Top-ranking reply

stfflspl

Level 3

587 points

Posted on Jul 31, 2022 7:44 AM

This happens automatically because by default the Data Format of a cell is set to "Automatic".

Two solutions to avoid the "automatic behaviour":

format the cell as TEXT before entering 3/467 like this: Cell>Data Format>Text
enter the text 3/467 after an apostrophe:' like this: '3/467 (Numbers will consider this as text)

Paul.

View in context

writing numbers in Numbers

Similar questions