Office challenge: Why is Excel creating two decimal places for input values?

In this week's Office challenge, help a frantic user discover why Excel insists on display two decimal places in all new input values.

Your first day back from holiday and a frantic user calls, describing a bizarre behavior in an Excel workbook. When she enters an integer, Excel enters two decimal places. For instance, if she enters 345, Excel turns it into 3.45.

You have her check the format and it's General. You have her change the format to Number with 0 decimal places, but Excel displays 3! You have her format a blank cell as Number with 0 decimal places. When she enters 345, Excel displays just 3.

Fortunately, within seconds, you have everything back to normal—what was wrong and how did you fix it?

Last week we asked…

How would you improve this userform? Everyone must have been on vacation last week! I'll leave this challenge open for another week so anyone who wants to participate has the opportunity!


Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

Editor's Picks

Free Newsletters, In your Inbox