csv to xls formatting problem
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 |
csv to xls formatting problem
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 wrote in message oups.com... | 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 | |
All times are GMT +1. The time now is 08:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com