Formula for correction

Closed
Shamim - Sep 5, 2015 at 02:00 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 8, 2015 at 11:33 AM
Hello,
The date is 12-July-2015 but in Excel the same is showing as 7-Dec-15
please suggest for the correction


1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Sep 8, 2015 at 11:33 AM
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
0