Cell default

  • Thread starter Thread starter PG
  • Start date Start date
P

PG

I export into csv some data that contains 11-20.
Unfortunately on opening the CSV it automatically changes
it into Nov-20. How can I get excel not to do this but
leave the text as 11-20. Unfortunately I can't change the
web export.
Thanks
 
Hi PG

Try to change the file format extension from .csv to .txt
When you open the file with Excel, you will have greater
flexibility to identify the different colums as text,
general, date, etc

HTH
 
You must log in or register to reply here.

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

["\r\n" new line command in CSV file] 1
Date Problem 2
Excel CSV Files; Creating Of 3
File Name Chages ? 1
How can I make Excel save Unicode CSV data correctly? 0
creating csv file 3
attach an Excel 2007 template 5
CSV->Excel Data Problem 1

Back
Top