ExcelBanter - Cell format dilema

ExcelBanter (https://www.excelbanter.com/)

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - Cell format dilema (https://www.excelbanter.com/setting-up-configuration-excel/450254-cell-format-dilema.html)

jeromeUAE

Cell format dilema

When I enter a whole number into a cell it changes to a decimal number? ie. I enter 21 and it is shown on the spreadsheet as 0.21 - I have tried different formats 'general' 'number' 'custom' with no correct result. When I change the decimal places to 0 - then the result on the spreadsheet is '0' I know that it is a setting somewhere, but would not know where to begin to look - any suggestions?

killme2008

You may try the "option"-"Advance"-"Auto input dilema"
Cancel it,it'll be OK!

All times are GMT +1. The time now is 03:53 AM.