csv to xls formatting problem

P

pmarinova

Field containing date 'dd-mm-yy' when exported to .xls retains its
format however if updated at a later time from the same format looses
its format (or some of the data being converted into mm-dd-yy)within
same .xls file. No problem if a new .xls [different name] is used but
this not satisfactory.

Thansk in advance for your sugestions.
Polina
 
N

Niek Otten

Hi Polina,

I don't quite understand what you mean, but try renaming the file to .txt (instead of .csv). Then importing it starts a wizard in
which you can specify the (date) format.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Field containing date 'dd-mm-yy' when exported to .xls retains its
| format however if updated at a later time from the same format looses
| its format (or some of the data being converted into mm-dd-yy)within
| same .xls file. No problem if a new .xls [different name] is used but
| this not satisfactory.
|
| Thansk in advance for your sugestions.
| Polina
|
 
Top