[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


how to convert dates into text  in MS Excel

Posted on 2011-02-10
Medium Priority
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
Question by:awesomejohn19
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 11

Accepted Solution

Runrigger earned 2000 total points
ID: 34864059

assumes your date is in cell C3

Expert Comment

ID: 34864066
LVL 39

Expert Comment

ID: 34864077
add a column with formula
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


Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
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 demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

656 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