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

@WilliamM11 

Select File > Options > Advanced.

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

If so, clear it.

HansVogelaar_0-1706912629033.png

@Hans Vogelaar 

 

Yes, it resolved the issue.  Thx,