Share via

Excel is converting numbers to % format

Anonymous
2025-03-21T19:44:18+00:00

I am experiencing an issue with Excel since yesterday, where it converts numbers to % format.

If I enter 5 it shows 0.05. I've tried changing from General to other formats including custom formats, but the issue persists.

The only way I can enter the number is as a text and then click on the warning symbol to convert it to a number.

This is really annoying when you have to enter a large amount of data,

Can anyone please give me some advice?

I'm running Excel 365, desktop application on Windows PC.

Thank you in advance for any help you can offer me.

Klaudia

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

Answer accepted by question author

Anonymous
2025-03-21T20:01:01+00:00

Dear respected Klaudia Seitz,

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

As per your description, check via go to File>Option>Advanced>uncheck "Automatically insert a decimal point" option. Then close the Excel file and reopen to check the outcomes.

Please understand that our initial reply may not always immediately resolve the issue. However, with your help and more detailed information, we can work together to find a solution.

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Waqas Muhammad

Was this answer helpful?

1 person found this answer helpful.
0 comments

Answer accepted by question author

HansV 462.6K Reputation points
2025-03-21T19:56:50+00:00

Select File > Options.

Select Advanced in the navigation pane.

If the check box "Automatically insert a decimal point" is checked, clear it.

Click OK.

Was this answer helpful?

1 person found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-03-21T20:48:34+00:00

    Thank you so much, this worked.

    You're a life saver.

    thank you for your prompt reply also :)

    Best regards,

    Klaudia

    Was this answer helpful?

    0 comments
  2. Anonymous
    2025-03-21T20:47:26+00:00

    Thank you so much for your help - you're a life saver!!!

    Excel is back to normal :)

    Best regards,

    Klaudia

    Was this answer helpful?

    0 comments