Converting Boolean Date to Text Date

[dbernart]

When I enter 1/1/2006 into Excel, it creates a Boolean value, correct? How can I convert this Boolean date to a text date such as "1/1/2006"?

Thanks!
Doug

 

[Norie]

When I enter 1/1/2006 into Excel, it creates a Boolean value, correct?

No.

Excel stores dates as integers, 1/1/2006 = 38718.

What do you actually want to do?

If you want to convert to text you can use the TEXT function.

=TEXT(A1, "dd/mm/yyyy")

Where A1 has the date.

 

[Andrew Poulsom]

When you enter 1/1/2006 in a cell you get a long integer, 38,718 to be precise. You can convert it to text like this:

=TEXT(A1,"dd/mm/yyyy")

 

[HalfAce]

Or... if you're just looking to display it as text...
Format the cell(s) as a date.
(Format > Cells > Number tab.)
Choose Date in the Category field and choose the format of your choice.