Share via

Wrong number format in cell

Anonymous
2018-06-02T03:38:10+00:00

Hello,

I am having problem with number formatting on my Excel 2016 for Mac. Every time I type decimal value, the cell keeps displaying wrong number and different format and. For example,

1.1 becomes 01.01

1.2 becomes 01.02 

1.25 becomes 01.25 

12.75 becomes 0,5520833

but when I type again 12,75 becomes 13,15 

What is wrong with my Excel. Can someone help me please. This is very frustrating.

Thank you in advance.

Best Regards,

Jukhi

Microsoft 365 and Office | Excel | For home | 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

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-06-02T05:40:06+00:00

    It’s the regional settings on your Mac. They affect how numbers are shown in Excel. There’s more info here:

    https://answers.microsoft.com/en-us/msoffice/fo...

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2018-06-02T04:04:05+00:00

    As additional information, I have to use comma for excel to correctly do calculation, for example, instead of type in 1.25 which will display 01.25, I must type it as 1,25. In this way I can get a proper calculation, e.g 1,25 + 1,25 = 2,5.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  3. Anonymous
    2018-06-03T14:58:38+00:00

    Great! I am glad that worked! If you don't have any more questions, feel free to choose a rating and have a great day!

    Was this answer helpful?

    0 comments
  4. Anonymous
    2018-06-03T08:23:25+00:00

    Thank you very much Jason, yes it's the regional settings that caused the problem.

    Was this answer helpful?

    0 comments