Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Covert Data the comes for a CVS
I have a file that is sent to me in a .CVS the date numbers so up as
20070220, I need it to be 20-Feb-07, everytime I try to do this I get the "railroad tracks" ########(yes my column is strecthed out). I tried every date format, custom formats, any help would be great. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Covert Data the comes for a CVS
Assume your "date" is in A1, then in a helper column you could enter
this formula: =VALUE(RIGHT(A1,2)&"/"&MID(A1,5,2)&"/"&LEFT(A1,4) Format the cell as dd-mmm-yy and then copy down for as many entries as you have in column A. Highlight all the cells with the formula in and click <copy, then Edit | Paste Special | Values (check) | OK then <Enter. This will have fixed the values. Then click <copy again and paste into column A to overwrite the values that are there. You can then delete the helper column. Another way would be to use Data | Text-to-Columns on column A, setting date format in the 3rd panel and copying over the data you have. Hope this helps. Pete On Mar 1, 6:58 pm, cyndi wrote: I have a file that is sent to me in a .CVS the date numbers so up as 20070220, I need it to be 20-Feb-07, everytime I try to do this I get the "railroad tracks" ########(yes my column is strecthed out). I tried every date format, custom formats, any help would be great. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do anyone know how to covert 912:30:44 into seconds | Excel Discussion (Misc queries) | |||
covert 72.8 to 72:48 | Excel Worksheet Functions | |||
covert columns into rows | Excel Discussion (Misc queries) | |||
How do I covert rows to columms? | Excel Worksheet Functions | |||
covert Cellular phone dec to hex | Excel Discussion (Misc queries) |