Forum Discussion

Copper Contributor

Dec 09, 2023

Format Cells

When I format cells in numbers or currency, the result displayed is incorrect. It works alright if I select 1 or 2 decimal places, but if I select 3 or more decimal places, the result is wrong. For e...

excel

Brian_Ashley

Copper Contributor

Dec 10, 2023

NikolinoDEThanks for your prompt reply to my decimal point problem.

I have checked all the things that you have suggested and the settings were all correct, but I still have the same problem. Could there be a problem with the system registry, which might have got changed without my knowledge or during a Window 10 update?

Brian_Ashley

Copper Contributor

Dec 11, 2023

In the Format Cells box, the fault is in the Number and Currency sections. If you click on a box in a spreadsheet with numbers or currency displayed correctly in it, then right click on Format Cells to show that cells existing format, the Sample shown at the top of that page displays incorrectly. For example: the cell contains the amount 8.000.00 €, but the sample shows 8.000.0.00 €. This is causing errors if I want to change the number of decimal points. It appears to be a problem within the Excel program.

Brian_Ashley