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.

User profile for user: hdjsfbkajsdvkavsnbnioasfhasklj
hdjsfbkajsdvkavsnbnioasfhasklj Author
User level: Level 1
4 points

Numbers changes "OCT" to "October," but autocorrect is disabled. What is going on?

I want my cell to say "OCT", the exact characters I typed (not more, not less). How can I do this?

Any and all suggestions are appreciated.


I have disabled all of the following in Numbers:

Edit>Spelling and Grammar>Check Spelling While Typing

Edit>Spelling and Grammar>Check Grammar With Spelling

Edit>Spelling and Grammar>Correct Spelling Automatically

Edit>Substitutions>Smart Quotes

Edit>Substitutions>Smart Dashes

Edit>Substitutions>Smart Links

Edit>Substitutions>Text Replacement

, but Numbers still changes "OCT" to "October."


Additional troubleshooting:

I have tried Command+Z, but this erases all the text in the cell, which is not what I want.

I have tried right-clicking, but no "undo autocorrect" option seems to exist.


Lastly, technical info, in case that helps:

Numbers version 3.6.1 (2566)

Macbook Pro (Retina, 15-inch, mid-2015)

macOS Catalina version 10.15.5

MacBook Pro 15″, macOS 10.15

Posted on Nov 10, 2021 6:28 PM

Reply
Question marked as Top-ranking reply
User profile for user: Barry
Barry
User level: Level 9
59,951 points

Posted on Nov 10, 2021 7:28 PM

Hi hdjsfbkajsdvkavsnbnioasfhasklj,


I suspect it's not autocorrect that's making the change. More likely is that the cell's data format is Automatic.


Numbers is recognizing OCT as a month name, and setting the cell's data format to Date and Time.

If that's the case, the actual content of the cell will be a Date and Time string for October 1, 2021 at 00:00:00 and the displayed value would be "October"


  • Click on the cell in question.
  • Click the Format button (top right)
  • Choose Cell
  • Change the Cell Data format from Automatic to Text.


Enter OCT



View in context

Similar questions

2 replies
Question marked as Top-ranking reply
User profile for user: Barry
Barry
User level: Level 9
59,951 points

Nov 10, 2021 7:28 PM in response to hdjsfbkajsdvkavsnbnioasfhasklj

Hi hdjsfbkajsdvkavsnbnioasfhasklj,


I suspect it's not autocorrect that's making the change. More likely is that the cell's data format is Automatic.


Numbers is recognizing OCT as a month name, and setting the cell's data format to Date and Time.

If that's the case, the actual content of the cell will be a Date and Time string for October 1, 2021 at 00:00:00 and the displayed value would be "October"


  • Click on the cell in question.
  • Click the Format button (top right)
  • Choose Cell
  • Change the Cell Data format from Automatic to Text.


Enter OCT



Reply

Numbers changes "OCT" to "October," but autocorrect is disabled. What is going on?

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