Excel 2016

[Lesleyfool]

I have upgraded to Excel 2016 and my spreadsheet is doing strange things.

It is suddently showing four decimal places on anything I input. I have managed to correct this but I notice that if I open a new worksheet if I input 55.00 for example it goes in as 55.000.

If I open a new worksheet and do the same it goes in as 55.00.

Can anyone help please?

[ReformedCharacter]

I have upgraded to Excel 2016 and my spreadsheet is doing strange things.

It is suddently showing four decimal places on anything I input. I have managed to correct this but I notice that if I open a new worksheet if I input 55.00 for example it goes in as 55.000.

If I open a new worksheet and do the same it goes in as 55.00.

Can anyone help please?

There are the usual options for cell formatting - Home > Format > Format Cells

You can set general preferences File > Options > Advanced > Editing Options > Automatically add decimal point (x places).

HTH

RC

[Breelander]

There are the usual options for cell formatting - Home > Format > Format Cells

You can set general preferences File > Options > Advanced > Editing Options > Automatically add decimal point (x places).

I note that LesleyFool seems to be complaining that this is only happening in spreadsheets that were created before upgrading to 2016. Newly created spreadsheets have 2 decimal places as expected, but opening a new worksheet in an old spreadsheet doesn't. Would your solution help in the case of opening a new worksheet in the old spreadsheets?

We also don't know what version of Excel these old spreadsheets were created by, that info may be relevant.

[ReformedCharacter]

There are the usual options for cell formatting - Home > Format > Format Cells

You can set general preferences File > Options > Advanced > Editing Options > Automatically add decimal point (x places).

I note that LesleyFool seems to be complaining that this is only happening in spreadsheets that were created before upgrading to 2016. Newly created spreadsheets have 2 decimal places as expected, but opening a new worksheet in an old spreadsheet doesn't. Would your solution help in the case of opening a new worksheet in the old spreadsheets?

We also don't know what version of Excel these old spreadsheets were created by, that info may be relevant.

By coincidence I have spent about the last 3 months developing an application in Excel, during that time I have upgraded Office from 2007 > 2010 > 2016 (don't ask why!). Checking sheets created in earlier versions I cannot reproduce that particular problem. I note the option I mentioned File > Options > Advanced > Editing Options is (or is at least on my upgrade) left blank and unselected by default.

RC

[Lesleyfool]

Hi

My previous version of excel was 2010 and i was on windows 10 and still am.

New workbooks are all fine. It does not have automatic decimal places ticked.

I have reformatted so that it is now two decimal places but im wondering if i need to copy it all into a new workbook?????????????????