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.

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

Reply
Question marked as Top-ranking reply

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":

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


Paul.

1 reply
Question marked as Top-ranking reply

Jul 31, 2022 7:44 AM in response to Trafficlaw

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


Two solutions to avoid the "automatic behaviour":

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


Paul.

writing numbers in Numbers

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