Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I convert dates to text keeping the format?
I'm trying to convert a column of data in date format *m/d/yyyy to a text
format without converting to serial numbers. Ie: I want to retain the mm/dd/yyyy format. Is there a way to do this? |
#2
|
|||
|
|||
=TEXT(A1,"MM/DD"/YYYY")
"sprlarry" wrote in message ... I'm trying to convert a column of data in date format *m/d/yyyy to a text format without converting to serial numbers. Ie: I want to retain the mm/dd/yyyy format. Is there a way to do this? |
#3
|
|||
|
|||
That places a formula in the field. I actually need a value with the
mm/dd/yyyy format to load to a different system. Any suggestions? "N Harkawat" wrote: =TEXT(A1,"MM/DD"/YYYY") "sprlarry" wrote in message ... I'm trying to convert a column of data in date format *m/d/yyyy to a text format without converting to serial numbers. Ie: I want to retain the mm/dd/yyyy format. Is there a way to do this? |
#4
|
|||
|
|||
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
How do I convert time format to text? | Excel Discussion (Misc queries) | |||
convert number to text and format it. | Excel Worksheet Functions | |||
convert number to text and format it. | Excel Worksheet Functions | |||
Convert text to dates | Excel Worksheet Functions |