how to convert dates into text in MS Excel

Lets say I have dates on MS Excel, for another project i need all dates cells as text.
So the date cells are currently formatted "custom" as "mmddyy". When I change the format to text it converts the day to a numbers. How would I prevent that? So I want the cell to be formatted as text but showing the date as mmddyy
awesomejohn19Asked:
Who is Participating?
 
RunriggerConnect With a Mentor Commented:
=TEXT(C3,"mmddyy")

assumes your date is in cell C3
0
 
pdd1lanCommented:
TEXT(B1,"mmddyy")
0
 
nutschCommented:
add a column with formula
=text(a1,"mmddyy")
assuming your date is in a1, then copy down the formula, copy the column, paste special / values and remove the first columns. Now your dates are text as mmddyy.

Screencast attached

Thomas
nutsch-408153.flv
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.