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 ...

Most numbers used in business are based on 10 – commonly known as the decimal system. One dollar is $1.00 and a half-dollar is $0.50. Time, of course, is an exception because it's based on 12. The day ...

Every now and then you come across something that Excel doesn’t have a function for which requires you to get fancy and figure out some tricky way to get the job done. While coding up a solution in ...

on a worksheet, but the same values may look awkward in an Excel chart. By default, charts use the same number format as the worksheet’s original data series. The good news is you do not have to ...