Disable conversion of two numbers with hyphen as date in Excel

Microsoft Excel has a feature that automatically coverts two numbers separated by hyphen in to a date formatted value. For example if you type 6-7 in a cell, Excel would reformat this in to a date value as 7-Jun. But if you do not want to reformat then you can use any of the below mentioned solutions to disable this feature.

Solution 1: Prefixing the values with apostrophe

The simplest solution is to add apostrophe before 6-7. This would display the typed value without reformatting it.

Auto format values with hyphen to date

Solution 2: Change format to Text Format

Another alternate solution is to change the formatting of the cell to Text format. Select the cell (or columns), right click and pick Format Cells from the menu list.

Format Cells in Excel

In the Format Cells window, select Text Format under Number tab and click OK button to apply the changes.

Change format to Text in Excel

Also See: How to prefix cell entry with zero in Excel 2013

In Category: Excel 2007, Excel 2010, Excel 2013, MS Office, Office 2007, Office 2010, Office 2013

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 2 Comments

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.