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

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

Frank Kabel

Hi Caine
one way:
=TEXT(A1,"mm/dd/yyyy")
where A1 stores your date value. Copy this down

Frank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with determining # of days from certain dates 2
How to count non blank cells with a condition? 1
Formula to fill cells based on Date of Arrival and Date of Departure 1
export data by selecting date range 5
What is the formula to convert a whole column of date to text? 2
separating date and time 5
Excel 2007 - calculating % of a year that has elapsed 5
Returning a Date with Multiple Criteria Lookup Values 0

Top