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!