Share via

MS Excel Date Default Formatted with Commas

Anonymous
2014-04-20T17:35:25+00:00

All the "/" date formats in my spreadsheets have suddenly changed to "," formats. This also includes the pulldown formats available in Format/Cells/Date Types. That is, these now show comas as the default.

For example:  4/20/2014 now shows as 4,20,2014. entering 4/20 results in 4,20. This happens when I open any of my previously formatted spreadsheets.

I've confirmed that my locale is set at English (U.S.).

I'd greatly appreciate help in understanding and correcting what happened.

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

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-04-21T14:30:46+00:00

    This worked! While all my regional date settings looked appropriate, hitting the "reset" button fixed all. Thanks!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more