<div>
<br />
mydate = format(&quot;myvalue&quot;, &quot;DDMMYYYY&quot;)
</div>


<div>
in my example 030271 this wil return 16111982 ??
</div>


in my example 030271 this wil return 16111982 ??

<div>
Just use a custom number format of:<br />
<br />
ddmmyy<br />
<br />
and enter your date normally.
</div>


Just use a custom number format of:

ddmmyy

and enter your date normally.

<div>
If you can use an adjacent cell, you can just use a formula:<br />
=TEXT(A1,&quot;00-00-00&quot;)+0<br />
for example.
</div>


If you can use an adjacent cell, you can just use a formula:
=TEXT(A1,"00-00-00")+0
for example.

<div>
<div class="content wysiwyg-content">
I use a cell format 00&quot;-&quot;00&quot;-&quot;00 to input a &quot;date&quot; like 030271 <br />
(3 febr. 1971) But the cell does not contain a date using this method. What code can I use with VBA to convert this cell to the proper date value? It's not a problem if the result will be put in a different cell.<br />
<br />
Thnx Remco
</div>
</div>


I use a cell format 00"-"00"-"00 to input a "date" like 030271 
(3 febr. 1971) But the cell does not contain a date using this method. What code can I use with VBA to convert this cell to the proper date value? It's not a problem if the result will be put in a different cell.

Thnx Remco

How to format a cell in Excel 2010 and back to a date value?

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