Converting numbers to date format from csv files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have data submitted as csv files which i have saved as excel spreadsheets.
Problem is the dates in the csv file are 20020105 etc, I need to convert
these to date format in order for me to calculate between sets of dates. All
I get is ###### (it's not a case of the column being too short). Tearing my
hair out
 
Hi
Select the column and use Data / Text to Columns. One of the dialog box
steps allows you to tell Excel that the value is a date - and how it is laid
out. I think it's the third box in and it says something like Column Data
Format in the top right corner.
 
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

Which is the best MBOX Converter Tool different formats conversion? 4
CSV->Excel Data Problem 1
Losing date format when saving .csv files 10
Excel CSV Files; Creating Of 3
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
csv not importing numbers stored as text 1
How to Export Gmail Emails to PST Format? 4
Convert csv to Excel files 1

Back
Top