View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Khaleel Khaleel is offline
external usenet poster
 
Posts: 7
Default 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