Converting Boolean Date to Text Date

dbernart

New Member
Joined
Aug 4, 2003
Messages
34
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
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,059
Office Version
  1. 365
Platform
  1. Windows
dbernart said:
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

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,453
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,680
Members
412,481
Latest member
nhantam
Top