Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Format Problem
I have downloaded data from our time keeping system which has dates in format
of M/D/YR (1/3/07) i would like them in the format of MM/DD/YY (01/03/07). I have tried date value formula, text to columns and format date options and I just get value error. I tried converting using error checking but that did not work either. Any suggestions. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Format Problem
Try:
=TEXT(DATEVALUE(A1),"MM/DD/YY") I have A1=1/3/07 as a TEXT field. HTH "Gayla" wrote: I have downloaded data from our time keeping system which has dates in format of M/D/YR (1/3/07) i would like them in the format of MM/DD/YY (01/03/07). I have tried date value formula, text to columns and format date options and I just get value error. I tried converting using error checking but that did not work either. Any suggestions. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Format Problem
Thanks for the info - but it still gives me #VALUE error. I just dont
understand. "Toppers" wrote: Try: =TEXT(DATEVALUE(A1),"MM/DD/YY") I have A1=1/3/07 as a TEXT field. HTH "Gayla" wrote: I have downloaded data from our time keeping system which has dates in format of M/D/YR (1/3/07) i would like them in the format of MM/DD/YY (01/03/07). I have tried date value formula, text to columns and format date options and I just get value error. I tried converting using error checking but that did not work either. Any suggestions. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Format Problem
You have invisible text characters in your import, it might be extra spaces
or html line feed Go here, install the macro (on the same site there are instructions on how to install macros) then select the imported "text" and run the macro, most likely you need to format the values as date after they have been converted. http://www.mvps.org/dmcritchie/excel/join.htm#trimall -- Regards, Peo Sjoblom "Gayla" wrote in message ... Thanks for the info - but it still gives me #VALUE error. I just dont understand. "Toppers" wrote: Try: =TEXT(DATEVALUE(A1),"MM/DD/YY") I have A1=1/3/07 as a TEXT field. HTH "Gayla" wrote: I have downloaded data from our time keeping system which has dates in format of M/D/YR (1/3/07) i would like them in the format of MM/DD/YY (01/03/07). I have tried date value formula, text to columns and format date options and I just get value error. I tried converting using error checking but that did not work either. Any suggestions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date format problem | Excel Worksheet Functions | |||
Date Format problem | Excel Discussion (Misc queries) | |||
Date conditioning format problem | Excel Discussion (Misc queries) | |||
date format problem | Excel Discussion (Misc queries) | |||
Problem with Date format from VBA code | Excel Discussion (Misc queries) |