Excel - Number formats

Question

When I insert for instance a 2 in a cell, it changes to 0.02 and a 7 to 0.07 etc. I have to insert it as 2.0 in order to get the number 2 only. I have tried all formats available but to no avail.

Answer 1

Perfect, thank you so much for your speedy assistance.

Kind regards

PG

Answer 2

Select File > Options > Advanced.

Clear the check box 'Automatically insert a decimal point'.

Click OK.

Answer 3

Dear respected PGLourens,

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

I’m sorry you’re having a problem but based on your description we can work together to resolve it.

For the situation you encountered, we deeply understand the inconvenience caused and apologize for it.

As per your description, check if this issue could also be caused by the setting that automatically inserts a decimal point, firstly, make sure you didn't select the option, "Automatically insert a decimal point**",** for your reference: Advanced options - Microsoft Support

Also, can you share a sample Excel file, and I will investigate an issue. If it is convenient for you, could you please send copy of your document file to me so that I can look from my side, and I will check this behavior and help you to fix and verify the result with you.

If there is confidential information, then you can send it to me in Private Message(PM). you can access PM from the top right corner of this page, as shown in image below:

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.

I'm sorry and I apologize for that.

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

Sincerely,

Waqas Muhammad