Decimal point in Excel - 200 appears as 2 when I press enter

[Jacaspace]

Hi,

Hope someone can help me. Somehow my entire Excel number format has changed. My Excel version is 2010.

Whenever I try to enter 200, it returns me as 2. Or 3000 as 30

I have checked all formats like General, Number etc but unable to find where the error is. (Please refer to attached image of the file)

Hope someone can help me to fix this.

Many Thanks!

[Pete_UK]

Click on the File button then on Excel Options (at the bottom of the panel) then on Advanced. Under Editing Options you probably have a check against Automatically Insert a Decimal Point, so uncheck this then click OK.

Hope this helps.

Pete

[oeldere]

@Jacaspace

Please change the excel version in your profile on this forum.

You add it as an 2003 version; In your text to speak of the 2010 version.

Maybe you can change it to 2010 version.

[Jacaspace]

Hi Pete,

Thank you so much! It was indeed the issue.

Cheers!