csv to xls formatting problem

  • Thread starter Thread starter pmarinova
  • Start date Start date
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
 
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
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert date to text without changing format dd/mm/yy 3
Losing date format when saving .csv files 10
Conditional formatting of date-cell - 2007 5
Weird date format problem 2
Date Format 2
Excel 2002: How to make the date format uniform ? 1
Can't graph data with Date Format with hours 2
Format Date ComboBox 4

Back
Top