Excel date format, NOT JUST DISPLAY !!
Hi,
i need the current date and time, in this format mm/dd/yyyy:hh:mm:ss
i used the custom format, to get the desired result.
But, wen i get into the edit mode (F2), it displays "6/25/2007 3:05:08 AM"
Please help me with this, i need to COPY the date in mm/dd/yyyy:hh:mm:ss
format.
Thanks in advance,
Regards,
Khaleel
|