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
>
>