Previous Topic Next Topic

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



Related:

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
nisha -
appu -

11 responses
Unable to change date format in Excel
rznbyz -
Tobby -

39 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses