How to convert DATE and TIME to text
 

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

Have you tried using the TEXT function?

e.g.

=TEXT(A1,"DD/MM/YYYY HH:MM:SS")

Assuming cell A1 contains date/time entry


--
humejap
------------------------------------------------------------------------
humejap's Profile: http://www.excelforum.com/member.php...fo&userid=5506
View this thread: http://www.excelforum.com/showthread...hreadid=395275

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

Did that, no avail. #NAME? error

Here's my worksheet looks like :


Date (cell A1)

8/9/2005 (cell A3, DATE format MM/DD/YYY)
8/10/2005 (cell A4, same DATE format as above)

If at cell C3 and C4 I want to display same date, but with TEXT format,
above formula won't work.

Any idea why ?

Thanks for the reply


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