These 6 Excel Number Formats Keep My Sheets From Falling Apart

Have you ever opened your spreadsheet only to find your carefully typed numbers missing their decimals, or worse, transformed into something like 2.95E+07? If yes, you’ve seen the downside of relying on Excel’s default General number format. It isn’t that Excel is wrong and you should start considering dumping it for Sheets; it’s that the default format constantly makes assumptions about how your data should appear, especially when a column gets too narrow or when the values are even slightly complex.