How to convert DATE and TIME to text

[ice_pack]

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 wit
simpler methods ?

Thanks a lo

 

[humejap]

Have you tried using the TEXT function?

e.g.

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

Assuming cell A1 contains date/time entr

 

[Guest]

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]

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 repl