Jump to content
Welcome Guest!

Join us now to get access to all our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, and so, so much more. It's also quick and totally free, so what are you waiting for?


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About spacecityguy

  • Rank
  1. Hi all, I thought I was a proficient Excel user, and I'm ashamed to say that I can't figure out how to solve this through this years (have done web searches every now and then). I just put up with it, but when I think how much time I have spent simply correcting Excel's automatic formatting, it hurts. I build a lot of Excel templates/models and often use complex formulas. I noticed ever since Excel 2007, when I edit a formula in a cell with number formatting applied to show whole numbers (no decimals) beforehand, Excel will ignore my number formatting and insert 2 decimal places to the result. I have tried the advanced option on automatic inserting decimal places and also pre-format all cells used in the formula have the same format but to no avail. Anyone know what causes this behavior and how to fix it? I initially thought it was a bug in Excel 2007 and MSFT would fix it in the next version, but it doesn't seem to be the case. So I think I'm missing something. Thanks.