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



2 replies

Blocked Profile
Nov 30, 2015 at 06:51 PM
You can format the text to a date using =text(string to change,"DDMMYY")
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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 + `
0
Blocked Profile
Dec 1, 2015 at 04:41 PM
If it didn't work, what result did you get?
0