Excel date format, NOT JUST DISPLAY !!

K

Khaleel

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
 
R

Rick Rothstein \(MVP - VB\)

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.
Click to expand...

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
 
K

Khaleel

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
 
R

Rick Rothstein \(MVP - VB\)

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!!!
Click to expand...

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
 
Top