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

Excel date format, NOT JUST DISPLAY !!
 

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.

Not sure if this will be a satisfactory solution, but if you need the
date/time in that exact format, you can use this formula to force it...

=TEXT(NOW(),"mm/dd/yyyy:hh:mm:ss")

Rick

Excel date format, NOT JUST DISPLAY !!
 

THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU,
THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU,
THANK YOU, THANK YOU, THANK YOU, THANK YOU,

i spent last 2 days trying to figure this out!!!!!
thanks man!!!
Regards,
khaleel

"Rick Rothstein (MVP - VB)" wrote:

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.

Not sure if this will be a satisfactory solution, but if you need the
date/time in that exact format, you can use this formula to force it...

=TEXT(NOW(),"mm/dd/yyyy:hh:mm:ss")

Rick

Excel date format, NOT JUST DISPLAY !!
 

THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK
YOU,
THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK YOU, THANK
YOU,
THANK YOU, THANK YOU, THANK YOU, THANK YOU,

i spent last 2 days trying to figure this out!!!!!
thanks man!!!

Let me guess... that solved your problem, right? <LOL

Usually I don't post back with a "You are welcome" message because I feel
that it is understood by the fact that I posted a response in the first
place; however, give the enthusiasm of your "thank you" message, I could not
resist. You are more than welcome... I am glad it helped to solve your
problem.

Rick