Share via

Use decimal points NOT commas

Anonymous
2022-11-30T14:51:27+00:00

Excel is not letting me use Decimal points, but has replaced them all with commas.

It's swapped the commas and decimal points round. This is the same in Word too - when using the dotted tab, it is reading the comma as a decimal point.

How do I set Excel and Word in the NORMAL way with decimal points? As it was before.

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
Answer accepted by question author
  1. Anonymous
    2022-11-30T15:06:46+00:00

    Dear HeatherChloe,

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

    As per your description, please don’t worry, we can work together to narrow down and resolve the situation.

    As far as I know, Excel takes that information from the system settings. You have to change the system-wide decimal separator in System Preferences.

    You may go to System Preference>Language & Region>Advanced>General>choose dot for the two options for Decimal>OK>Restart your Mac and check the result in Excel.

    Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

    Sincerely,

    Waqas Muhammad

    2 people found this answer helpful.
    0 comments
Answer accepted by question author
  1. riny 20,530 Reputation points Volunteer Moderator
    2022-11-30T15:03:53+00:00

    Check the Language & Region settings. Here you can determine how your Mac should format numbers, dates and times.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest