Excel Number Format (Autocorrect?) Issue

[NukedWhale]

Hello,

I'm having an issue with excel number formatting/auto correct. I'm not sure which one.

I have a cell formatted as a number to two decimal places, but when I type in something like 3.50, it's automatically truncating it to 3.5.

Is there anyway to disable this feature? I need it to always display 2 decimal places, even if that last decimal place is 0.

Thanks

[mgmgrand]

Make sure you have your decimal places set to 2. Right click on the cell, format cells, number tab, category (left side) = Number, decimal places (right side) = 2.

That should solve your problem.

[NukedWhale]

That was already done.

[puntoMX]

Then it should work... Please check the Cell-formatting again like mgmgrand said and make sure it’s set on numbers.

When you make a new document, does it work then? If so, your Excel sheet is messed up.