Date Entry & Display

[Closed]
Report
-
Posts
5
Registration date
Saturday May 2, 2009
Status
Member
Last seen
June 14, 2009
-
Hello,
I have a problem while entering date in the excel sheet, by Date/Month/Year (dd/mmdyy) form, it displays in Month/Date/Year (mm/dd/yy) form. How can I rectify this. I tried by changing in the format window in its "Date" and "Custom" but failed. Awaiting for your valued reply.

Sura

1 reply

Posts
5
Registration date
Saturday May 2, 2009
Status
Member
Last seen
June 14, 2009
4
hye you can check this tutorial for help:

https://www.techonthenet.com/excel/questions/remove_time.php