​​ ​

The Apple Support Community will permanently close on November 20, 2026. Starting today, the site will no longer accept new posts and is available in a read-only state.


You can continue to find trusted guidance and support on the official Apple Support site. 


We want to thank the community members who have contributed their time and expertise to help others with their Apple products.


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

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.

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.

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.