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

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