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 response

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