Sometimes it's not possible to separate data yourself before putting it into an Excel spreadsheet. Often, the information from old data files gets lumped into a single cell. The same can happen if you ...

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

Type an apostrophe before entering or pasting two numbers separated by a hyphen in Microsoft Excel to keep the numbers from being converted to their month and date equivalent. Dennis O'Reilly Former ...