• Skip to main content
  • Skip to primary sidebar

Ravi Shankar

Tweaking Apps

  • Swift
  • Tech Tips
You are here: Home / Excel / Disable conversion of two numbers with hyphen as date in Excel

Disable conversion of two numbers with hyphen as date in Excel

July 14, 2014 By Ravi Shankar Leave a Comment

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

Filed Under: Excel, Excel 2007, Excel 2010, Excel 2013, MS Office, Office 2007, Office 2010, Office 2013 Tagged With: Apostrophe, disable date, Format Cells, hyphen

Reader Interactions

Trackbacks

  1. How to insert to current date and time in Excel says:
    October 4, 2014 at 11:46 am

    […] Also See: Disable conversion of two numbers with hyphen as date in Excel […]

    Reply
  2. How to change date system for a workbook in Excel says:
    October 26, 2015 at 10:30 am

    […] Also See: Disable conversion of two numbers with hyphen as date in Excel […]

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

TwitterLinkedin

Recent Posts

  • How to set preferred Wifi network on Mac
  • Attribute Unavailable: Estimated section warning before iOS 11.0
  • How to recover Firefox password from Time Machine backup
  • Show hidden files and folders on Mac
  • How to request a refund for apps in App Store

Pages

  • About
  • Privacy Policy
  • Terms and Conditions

Copyright 2022 © rshankar.com

Terms and Conditions - Privacy Policy