Weird date display in excel

Closed

bellydancemichelle - Nov 30, 2015 at 06:09 PM
Blocked Profile - Dec 1, 2015 at 04:41 PM

Hello,

This seems like a really simple problem to solve but totally has me stumped.

I have entered my date as 30/11/15 (DMY) into the excel cell yet it displays as 42338. I have checked and confirmed "Date" has been selected as the number format.
The date displays perfectly in the formula bar but not from the cell.

Please help me fix this.
Michelle

Weird date display in excel
Excel date format dd.mm.yyyy - Guide
Number to words in excel - Guide
Gif in excel - Guide
Marksheet in excel - Guide
Huawei display check code - Guide

2 responses

Answer 1 / 2

Blocked Profile
Nov 30, 2015 at 06:51 PM

You can format the text to a date using =text(string to change,"DDMMYY")

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 1, 2015 at 12:29 PM

Check if Show Formula is turned on. On windows you can toggle between show and hide by using short cut Ctrl + `

Answer 2 / 2

Blocked Profile
Dec 1, 2015 at 04:41 PM

If it didn't work, what result did you get?

Similar discussions

Date formatting in dd/mm/yyyy

How to calculate positions (1st,2nd,3rd...) in Excel

Similar discussions

Subscribe To Our Newsletter!