Date Entry & Display

Closed
Sura - Jun 11, 2009 at 03:00 AM
b.notso
Posts
5
Registration date
Saturday May 2, 2009
Status
Member
Last seen
June 14, 2009
- Jun 11, 2009 at 11:52 AM
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

b.notso
Posts
5
Registration date
Saturday May 2, 2009
Status
Member
Last seen
June 14, 2009
4
Jun 11, 2009 at 11:52 AM
hye you can check this tutorial for help:

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