Share via

excel flips ACN to CAN, how to correct

Anonymous
2018-01-11T15:25:31+00:00

I type ACN in my excel from office 365 and it auto corrects to CAN, why does it do that, it must be a bug, how to fix, as this is a stock quote and is part of a live spread sheet.

JD

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
Answer accepted by question author
  1. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2018-01-11T15:28:24+00:00

    Open Excel

    File > Options > Proofing > AutoCorrect Options

    Type ACN in Replace: box

    Now CAN will automatically appear in With: box

    You may be required to select this in down box if not automatically selected

    Now press Delete

    40+ people found this answer helpful.
    0 comments No comments
Answer accepted by question author
  1. DaveM121 869K Reputation points Independent Advisor
    2018-01-11T15:30:12+00:00

    Ho John, this is one of the most commonly mis-spelled words, so it is in the Autocorrect in Excel

    In Excel, go to File - Options

    Go to Proofing - Autocorrect Options

    Scroll down to find acn, select and delete that entry to stop this behavior

    That's It

    20+ people found this answer helpful.
    0 comments No comments

3 additional answers

Sort by: Most helpful
  1. DaveM121 869K Reputation points Independent Advisor
    2018-01-11T16:50:02+00:00

    Glad to help, if you have any more questions, please contact us here at MS Community!

    0 comments No comments
  2. Anonymous
    2018-01-11T15:32:11+00:00

    Ho John, this is one of the most commonly mis-spelled words, so it is in the Autocorrect in Excel

    In Excel, go to File - Options

    Go to Proofing - Autocorrect Options

    Scroll down to find acn, select and delete that entry to stop this behavior

    That's It

    thanks that worked

    0 comments No comments
  3. Anonymous
    2018-01-11T15:31:01+00:00

    awesome that worked, been bugging forever

    0 comments No comments