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
Transfer data from one excel worksheet to another automatically - Guide
Cs 1.6 code - Guide
Excel mod apk for pc - Download - Spreadsheets
How to refresh outlook inbox automatically - Guide
Why does facebook refresh itself automatically - 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

lava hard reset & factory reset

Why does our account keep randomly following additional users every few weeks?

How to unlock Gameloft games

unlock codes

Samsung mobiles Nitro racing code

Similar discussions

Subscribe To Our Newsletter!