C
Caine Phorn
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!
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!