• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Digital Answers

How to tech tutorials in simple words

  • Home
  • About Us
  • Disclaimer
  • Privacy Policy

Disable conversion of two numbers with dash as date in Excel

March 10, 2023 by Admin 3 Comments

Microsoft Excel has a feature that automatically coverts two numbers separated by dash 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 add country code to phone numbers in Excel

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
  3. How to display fractions in Excel - Digital Answers says:
    December 17, 2022 at 1:25 pm

    […] You might be interested in this post as well – Disable conversion numbers with dash to dates in Excel […]

    Reply

Leave a Reply Cancel reply

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

Primary Sidebar

Recent Posts

  • Disable conversion of two numbers with dash as date in Excel
  • How to Protect Formulas in Excel
  • How to Change the Default Font in Excel
  • How to Add Country Code to Phone Automatically in Excel
  • How to Insert Pictures in Excel

blogmines.com Copyright © 2023