<div>
I found this to convert Excel serial date to regular date format.<br />
<br />

<pre><code id="code-20-39846151-1">=UPPER(TEXT(A1,&quot;mmm-d&quot;))</code></pre>
<br />
You can probably mes around with the &quot;mmm-d&quot; part to get the exact format you want.
</div>


I found this to convert Excel serial date to regular date format.



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


You can probably mes around with the "mmm-d" part to get the exact format you want.

<div>
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,<br />
<br />
Today's date (10/2/2014) has the value of 41680 in Excel.<br />
<br />
Can you give some examples of the 10 digit numbers, and the dates that they represent?
</div>


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?

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I download a CSV file and when I open the file I see the dates as serial numbers(10 digits).<br />
I tried to change the format cells to date but still doesn't work.<br />
<br />
Please advise
</div>
</div>


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

Dates appears as serial numbers

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.