Formula for correction

Closed
Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
Hello,
The date is 12-July-2015 but in Excel the same is showing as 7-Dec-15
please suggest for the correction


1 reply

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi Shamim,

Apparently the day and month have switch places.

Try adjusting the cells format by hitting Ctrl+1 and find the desired way to display the date.

Best regards,
Trowa