How To Keep Dates As Text In Excel
Updated September 13, 2017 Adding an Apostrophe Select the cell in which you want to type a date. This method works best when you have only a few dates to enter. Press the “apostrophe” key to insert an apostrophe as the first character of the cell, forcing Excel to keep the data formatted as text instead of converting it to a number. Type the date and press “Enter.” Although the apostrophe remains in the cell and you can see it in the formula bar, it is invisible in the cell itself....