Changing date format into a text format
Closed
cdumais
Posts
1
Registration date
Thursday November 17, 2016
Status
Member
Last seen
November 17, 2016
-
Nov 17, 2016 at 04:07 PM
fdibbins Posts 33 Registration date Sunday June 19, 2016 Status Contributor Last seen November 20, 2016 - Nov 20, 2016 at 07:21 PM
fdibbins Posts 33 Registration date Sunday June 19, 2016 Status Contributor Last seen November 20, 2016 - Nov 20, 2016 at 07:21 PM
Related:
- Changing date format into a text format
- Excel date format dd.mm.yyyy - Guide
- Format factory - Download - Other
- Samsung format code - Guide
- Kingston format utility - Download - Storage
- Marksheet format in excel - Guide
2 responses
yg_be
Posts
23239
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
October 4, 2024
5
Nov 17, 2016 at 04:35 PM
Nov 17, 2016 at 04:35 PM
do you mean you want to replace the content of cells containing dates, and store text instead?
could you explain why you want to do that?
could you explain why you want to do that?
fdibbins
Posts
33
Registration date
Sunday June 19, 2016
Status
Contributor
Last seen
November 20, 2016
1
Nov 20, 2016 at 07:21 PM
Nov 20, 2016 at 07:21 PM
1st, you need to make sure that your "date" really IS a date, and not text that just looks like a date - text with =isnumber(A1) where A1 is the cell containing your date. FALSE tells you that is not a real date.
What you need to understand about dates and times in excel is…
a date is just a number representing the number of days passed since 1/1/900...and then formatted in a way that we recognize as a date. So, for instance, today (Sun 20 Nov 2016) is actually 42694
Time is actually a decimal part of 1 (day), so 06:00 AM is 0.25, 12 noon is 0.5 and 18:00 (or 6 PM) is 0.75
So, having said that, and assuming that you really DO have dates, you just need to change the date format to suite your needs.
rt click the cell, select Format, then select Date from the window that appears. You will see a number of different formats, pick 1 that suites your needs
What you need to understand about dates and times in excel is…
a date is just a number representing the number of days passed since 1/1/900...and then formatted in a way that we recognize as a date. So, for instance, today (Sun 20 Nov 2016) is actually 42694
Time is actually a decimal part of 1 (day), so 06:00 AM is 0.25, 12 noon is 0.5 and 18:00 (or 6 PM) is 0.75
So, having said that, and assuming that you really DO have dates, you just need to change the date format to suite your needs.
rt click the cell, select Format, then select Date from the window that appears. You will see a number of different formats, pick 1 that suites your needs
