Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert dates stored as dates to text?
So basically... I have some dates stored as dates in Excel that I want to
convert to text without getting wacky numbers (i.e. I still want them to display as the date, just categorized as text) any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert dates stored as dates to text?
=TEXT(A1,"mm/dd/yy")
replace the date format (US in my example) to whatever date format you are using -- Regards, Peo Sjoblom "diamunds" wrote in message ... So basically... I have some dates stored as dates in Excel that I want to convert to text without getting wacky numbers (i.e. I still want them to display as the date, just categorized as text) any ideas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert dates stored as dates to text?
How about some examples?
-- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "diamunds" wrote in message ... So basically... I have some dates stored as dates in Excel that I want to convert to text without getting wacky numbers (i.e. I still want them to display as the date, just categorized as text) any ideas? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert dates stored as dates to text?
Use the following formula, changing the cell address and date format =TEXT(A1,"dddd, mmmm d, yyyy") A1 is the cell with the date "dddd, mmmm d, yyyy" is the format mask that would produce Friday, September 7, 2007 -- Kevin Backmann "diamunds" wrote: So basically... I have some dates stored as dates in Excel that I want to convert to text without getting wacky numbers (i.e. I still want them to display as the date, just categorized as text) any ideas? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert dates stored as dates to text?
=TEXT(A1,"mm/dd/yyyy")
Assuming you have a date in A1 You can then CopyPasteSpecialValue if you need to remove the formula... "diamunds" wrote: So basically... I have some dates stored as dates in Excel that I want to convert to text without getting wacky numbers (i.e. I still want them to display as the date, just categorized as text) any ideas? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert dates stored as dates to text?
(In xl2000+) try copy and pasting the date range as formatted text:
1. Press Ctrl+C twice, format number as text and click the paste icon. 2. Then undo and paste special as text [only for small ranges <2k]. "diamunds" wrote: So basically... I have some dates stored as dates in Excel that I want to convert to text without getting wacky numbers (i.e. I still want them to display as the date, just categorized as text) any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert text to dates | Excel Discussion (Misc queries) | |||
Convert Dates to text | Excel Discussion (Misc queries) | |||
Converting numbers stored as dates to text in Excel | Excel Discussion (Misc queries) | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Convert text to dates | Excel Worksheet Functions |