Solved

how to convert dates into text  in MS Excel

Posted on 2011-02-10
3
316 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:awesomejohn19
3 Comments
 
LVL 11

Accepted Solution

by:
Runrigger earned 500 total points
ID: 34864059
=TEXT(C3,"mmddyy")

assumes your date is in cell C3
0
 
LVL 8

Expert Comment

by:pdd1lan
ID: 34864066
TEXT(B1,"mmddyy")
0
 
LVL 39

Expert Comment

by:nutsch
ID: 34864077
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

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question