• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 252
  • Last Modified:

Dates appears as serial numbers

Hi Experts,

I download a CSV file and when I open the file I see the dates as serial numbers(10 digits).
I tried to change the format cells to date but still doesn't work.

Please advise
0
chenzovicc
Asked:
chenzovicc
1 Solution
 
TheNauticanCommented:
I found this to convert Excel serial date to regular date format.

=UPPER(TEXT(A1,"mmm-d"))

Open in new window


You can probably mes around with the "mmm-d" part to get the exact format you want.
0
 
GrahamSkanRetiredCommented:
Without any other information it is hard to guess how the dates have been converted to numbers, and hence how to convert them back again,

Today's date (10/2/2014) has the value of 41680 in Excel.

Can you give some examples of the 10 digit numbers, and the dates that they represent?
0
 
Harry LeeCommented:
When you say 10-Digit time, I believe you are talking about unix time.

try use the following formula to convert the timestamp.

Put the 10-Digit date in A1, then the formula in another cell.

=A1/(60*60*24)+"1/1/1970"

After that, format the formulated cell to Date format in excel.
0
 
chenzoviccAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now