Link to home
Create AccountLog in
Avatar of A G
A GFlag for United States of America

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Runrigger
Runrigger
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of pdd1lan
pdd1lan

TEXT(B1,"mmddyy")
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