Anyone else encountering this Excel bug

KCA 40 Reputation points
2025-09-04T22:28:22.4466667+00:00

Anyone else seen this bug, US English version of Excel for Mac, 16.000.01:

--> Format Cell interface --> set custom format to "0000"

Format Cell Interface now opens directly to the "special" number format submenu AND the language is set to Bashkir. Setting language back to any English variant other than "American" changes the number format to "00000". Set to American English, and the number format gets set to "Social Security Number". Screenshot 2025-09-04 at 2.28.26 PM

Microsoft 365 and Office | Excel | Other | MacOS
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Jeronimo Fuerte 26,440 Reputation points Independent Advisor
    2025-09-04T23:11:17+00:00

    Hi! Seems that when you enter a custom format like 0000, the Format Cells window wrongly jumps to Special and even flips the language.. It may also swap your mask to “Social Security Number” or 00000. Your data isn’t harmed, this is just the formatting dialog getting confused.

    Try to type a locale-locked custom format such as [$-en-US]0000 so Excel won’t switch categories, or use a formula like =TEXT(A1,"0000"). If you still see odd behavior, update Excel and, if needed, reset Excel preferences. Please also send Help > Feedback with your build number.


  2. Jeronimo Fuerte 26,440 Reputation points Independent Advisor
    2025-09-07T00:52:09.0333333+00:00

    I see, you are correct, newer releases don't have this, please try the Feedback portal:
    https://feedbackportal.microsoft.com/feedback/


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.