Excel is automatically changing dates to a numeric code

Solved/Closed

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
Battery reset code - Guide
How to get whatsapp verification code online - Guide
Samsung volume increase code - Guide
Transfer data from one excel worksheet to another automatically - Guide
Cs 1.6 code - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Nov 10, 2015 at 11:17 AM

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

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!!

Similar discussions

Unlock code

How to unlock Gameloft games

lava hard reset & factory reset

Similar discussions

Subscribe To Our Newsletter!