Share via

Excel using , ??

Anonymous
2024-11-15T01:42:49+00:00

I'm using excel. why are my numbers now using a , instead of a . between dollars and cents?

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 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-11-15T03:08:16+00:00

    Hi Beachmaya,

    Thanks for visiting Microsoft Community.

    It seems that you are experiencing an issue with separators in Excel.

    You can go to File-Options-Advanced, and under Editing options, find the following two settings and change them to what you need. For example, change the thousands separator to "." and the decimal separator to ",".

    The effect after the change is shown in the picture:

    I hope this can solve your problem. If you need further assistance, please feel free to reply.

    Best Regards,

    Jonathan Z - MSFT | Microsoft Community Support Specialist

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2024-11-17T02:40:29+00:00

    Thank you so much. It appeared to be set as I wanted it - with a . for decimal and a , for thousands - I clicked off and on and it appears to have reset appropriately.

    Was this answer helpful?

    0 comments