<div>
If yor cell with date is A1, you can use:<br />
=YEAR(A1)*10000+MONTH(A1)*<wbr />100+DAY(A1<wbr />)
</div>


If yor cell with date is A1, you can use:
=YEAR(A1)*10000+MONTH(A1)*100+DAY(A1)

<div>
The correct way would actually be to press Ctrl+1 ( or right click and choose Format cells) go to custom format, and write yyyymmdd or yyyyddmm which ever you prefer. <br />
With this you achieve precisely what you want. You still have the same data, but in the format you desire. <br />
Best of &nbsp;luck. 
</div>


The correct way would actually be to press Ctrl+1 ( or right click and choose Format cells) go to custom format, and write yyyymmdd or yyyyddmm which ever you prefer.
With this you achieve precisely what you want. You still have the same data, but in the format you desire.
Best of  luck.

<div>
.....I think that's exactly what gmollineau is trying to avoid GasperK. If you do that then the format only is changed (not the cell contents) and if you change the format to general you'll see a number like 40179.<br />
<br />
My suggestion and the suggestion of als315 both use an extra cell to do the conversion, you can only change the cell content &quot;in situ&quot; if you use VBA.<br />
<br />
regards, barry
</div>


.....I think that's exactly what gmollineau is trying to avoid GasperK. If you do that then the format only is changed (not the cell contents) and if you change the format to general you'll see a number like 40179.

My suggestion and the suggestion of als315 both use an extra cell to do the conversion, you can only change the cell content "in situ" if you use VBA.

regards, barry

<div>
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

<div>
<div class="content wysiwyg-content">
I have an Excel file with one column of DATE format field. I want to convert this to a number but keep the same data. for example 20110101 should stay as 20100101 (as a NUMBER format) instead of 40179 that Excel converts it to if I do a change format.
</div>
</div>


I have an Excel file with one column of DATE format field. I want to convert this to a number but keep the same data. for example 20110101 should stay as 20100101 (as a NUMBER format) instead of 40179 that Excel converts it to if I do a change format.

Convert Excel date to the same number

Exchange is the server side of a collaborative application product that is part of the Microsoft Server infrastructure. Exchange's major features include email, calendaring, contacts and tasks, support for mobile and web-based access to information, and support for data storage.

Exchange

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