Thousand separator NOT WORKING on Excel for Mac 16.62 - Monterey 12.4

Anonymous
2022-07-10T19:10:30+00:00

I am really, REALLY tired of trying to find a solution for this.

My Excel for Mac doesn't recognize my regional settings. I've tried EVERYTHING available on the internet, and even spent 1+ hour with MS support on chat trying to fix my issue.

My region is set to United States (Custom), with the thousand separator being comma and decimal dot.

However, when I try to format something on Excel, this happens.

I work in finance so number formats are KEY to build effective spreadsheets and financial models. I'm hopeless.

I've tried:

  • Changing the region
  • Reinstalling MS Office 365
  • Booting on safe mode
  • Deleting plist and stuff
  • Changing the region through terminal

NONE of the above have solved the problem.

If someone has any advice I'd appreciate.

Microsoft 365 and Office | Excel | For business | MacOS

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
{count} votes
Answer accepted by question author
  1. Anonymous
    2022-07-11T09:51:55+00:00

    Dear Leonardo,

    Thanks for posting back.

    Normally, when you change the settings in Language & Region, then restart Mac, the thousand separator in Excel will be changed. As you mentioned you have reinstalled Office, I would like to know how you uninstalled Office. If you moved Office applications to Trash, then reinstalled Office. Please try to completely uninstalled Office, then check if the situation still happens.

    We look forward to your response. Thanks for your cooperation.

    Sincerely,

    George | Microsoft Community Moderator

    ***Note: In the event that you're unable to reply to this thread, please ensure that your Email address is verified in the Community Website by clicking on Your Account Name > "My Profile" > "Edit Profile" > Add your Email Address > tick "Receive email notifications" checkbox > click on "Save".***

    1 person found this answer helpful.
    0 comments No comments

6 additional answers

Sort by: Most helpful
  1. Anonymous
    2022-07-10T20:15:28+00:00

    Anyone? I'm almost willing to pay someone to find me a solution

    0 comments No comments
  2. Anonymous
    2022-07-10T20:47:46+00:00

    Dear Leonardo,

    Good day! Thanks for posting in Microsoft Community. We are happy to help you.

    According to your description, I would like to know if you have tried to restart your Mac, then check again.

    If so, please switch to another Mac user profile (if you don’t have another user profile, please create a new Mac user profile, then switch to the new user profile), run Excel, and check again.

    We look forward to your response. Thanks for your cooperation.

    Sincerely,

    George | Microsoft Community Moderator

    ***Note: In the event that you're unable to reply to this thread, please ensure that your Email address is verified in the Community Website by clicking on Your Account Name > "My Profile" > "Edit Profile" > Add your Email Address > tick "Receive email notifications" checkbox > click on "Save".***

    0 comments No comments
  3. Anonymous
    2022-07-10T20:59:34+00:00

    Didn't work

    0 comments No comments
  4. Anonymous
    2022-07-11T17:17:17+00:00

    PLEASE CAN SOMEONE BRING AN OSCAR TO THIS GUY!

    After WEEKS of research and support, your suggestion solved my problem. I completely uninstalled office and reinstalled again and now it works!

    Thank you

    0 comments No comments