Yes, it works.

Thank you,

"Dave Peterson" wrote:

This worked for me with my USA date settings (mdy):
=--TEXT(A1,"00\/00\/0000")
and formatted as a date



Happy One wrote:

How to change the number 1122008 to 1/12/2008?

--

Dave Peterson