Formula for correction

[Closed]
Report
-
Posts
2783
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 3, 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
2783
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 3, 2021
468
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!