Use the TEXT() function

To convert a date value

=TEXT(TODAY(),"MM/DD/YY")

Same thing with time

=TEXT(NOW(),"hh:mm:ss")



"ice_pack" wrote:


Hi,

I am having problem to convert cells with DATE and TIME format to text.
I tried virtually anything but VBA programming. Anybody can help with
simpler methods ?

Thanks a lot


--
ice_pack
------------------------------------------------------------------------
ice_pack's Profile: http://www.excelforum.com/member.php...o&userid=26232
View this thread: http://www.excelforum.com/showthread...hreadid=395275