Formula for correction

Closed
Shamim - Sep 5, 2015 at 02:00 AM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 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 reply

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
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