Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 11:00 AM (PST)
Microsoft Tech Community

Microsoft Excel Formula Assistance

Copper Contributor

When inputting a 1 in a cell the display is 0.01.  Please advise how to correct this issue.  Thx, 

2 Replies


Select File > Options > Advanced.

Under 'Editing options', is the check box 'Automatically insert a decimal point' ticked?

If so, clear it.


@Hans Vogelaar 


Yes, it resolved the issue.  Thx,