The simplest way to add an apostrophe before a date in Excel is to type it directly before the date when entering it in a cell. This method works best when you’re dealing with a small number of ...

When you type a seven-or-ten-digit phone number into an Excel cell that uses the phone number format, Excel will automatically change the way the number looks so that it appears as a phone number. If ...