Excel is automatically changing dates to a numeric code [Solved/Closed]

Question

Excel is automatically changing dates to a numeric code [Solved/Closed]

Report

mamagiglio

Posts: 2
Registration date: Tuesday November 10, 2015
Status: Member
Last seen: November 10, 2015

- Nov 10, 2015 at 10:59 AM
mamagiglio

Posts: 2
Registration date: Tuesday November 10, 2015
Status: Member
Last seen: November 10, 2015

- Nov 10, 2015 at 11:31 AM

Hello,

I'm using Excel and when I put a date in a column it changes to a numeric code. For example: 4/5/15 now reads 42099. I've tried highlighting the columns and formatting it for date, but it doesn't work. The date appears in the function bar when I click on an particular cell, though.

Thanks for your help!

Excel is automatically changing dates to a numeric code
Excel - A macro to get the equivalent numerical codes for colors - How-To - Excel
Excel how to change a value automatically ✓ - Forum - Excel
Excel author name change - How-To - Excel
Excel how to change date format to dd/mm/yyyy - How-To - Excel
Excel if function with dates - How-To - Excel

1 reply

Ask a question

rizvisa1 · Accepted Answer · 2015-11-10T11:17:31-0500

Answer 1 / 1

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

767
Nov 10, 2015 at 11:17 AM

I think you have Show Formula option enabled. Try pressing CTRL and ` together

Report

mamagiglio

Posts: 2
Registration date: Tuesday November 10, 2015
Status: Member
Last seen: November 10, 2015

Nov 10, 2015 at 11:31 AM

Thanks! I highlighted the worksheet and then the shortcut worked. Woot!!

Excel is automatically changing dates to a numeric code [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!