What is the formula to convert a whole column of date to text?
 

What is the formula to convert a whole column of date to text?

If I am to do it cell by cell, I need to press F2 then put a -- ' in
front of the date.

Is there a way I can do it with formula? I have tried CONCATENATE to
combine column a which contains ' with date 12/31/03.

Column A Column B
' 12/31/03 =CONCATENATE(A1,B1)

However, the end result I got is as follow.

'37986

instead of

'12/31/03

Please help!

What is the formula to convert a whole column of date to text?
 

Hi Caine
yee your responses in the other group (Excel.newusers)
Frank
P.S.: please don't multipost as this scatters your answers

Caine Phorn wrote:
What is the formula to convert a whole column of date to text?

If I am to do it cell by cell, I need to press F2 then put a -- '
in front of the date.

Is there a way I can do it with formula? I have tried CONCATENATE to
combine column a which contains ' with date 12/31/03.

Column A Column B
' 12/31/03
=CONCATENATE(A1,B1)

However, the end result I got is as follow.

'37986

instead of

'12/31/03

Please help!

What is the formula to convert a whole column of date to text?
 

I don't know why you're unsatisfied with the way Excel handles dates. Maybe
you don't like the formatting?
What's your goal?

=TEXT(A1, "dd-mm-yyyy")


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Caine Phorn" wrote in message
...
What is the formula to convert a whole column of date to text?

If I am to do it cell by cell, I need to press F2 then put a -- ' in
front of the date.

Is there a way I can do it with formula? I have tried CONCATENATE to
combine column a which contains ' with date 12/31/03.

Column A Column B
' 12/31/03 =CONCATENATE(A1,B1)

However, the end result I got is as follow.

'37986

instead of

'12/31/03

Please help!