Retaining date formatting in referencing cell
 

Hello,

I have a formula in cell D4 that contains a reference to cell C2 which
contains a date. Cell C2 is formatted to display its information as a date.
How do I retain the date formatting of the information contained in cell C2
when it is displayed in cell D4?

The date that is in cell C2 is: 11/1/2006
And the formula that is in cell D4 is: = "'" & C2 & "'"

Cell D4 displays like this: '39022'
But I want cell D4 to display like this: '11/1/2006'

Thank you.

Sincerely,

Corey Foote

Retaining date formatting in referencing cell
 

= "'" & TEXT(C2,"mm/d/yyyy") & "'"
--
David Biddulph

"Corey Foote" <Corey wrote in message
...
Hello,

I have a formula in cell D4 that contains a reference to cell C2 which
contains a date. Cell C2 is formatted to display its information as a
date.
How do I retain the date formatting of the information contained in cell
C2
when it is displayed in cell D4?

The date that is in cell C2 is: 11/1/2006
And the formula that is in cell D4 is: = "'" & C2 & "'"

Cell D4 displays like this: '39022'
But I want cell D4 to display like this: '11/1/2006'

Thank you.

Sincerely,

Corey Foote

Retaining date formatting in referencing cell
 

Try this:

=TEXT(C2,"'m/d/yyyy'")


"Corey Foote" wrote:

Hello,

I have a formula in cell D4 that contains a reference to cell C2 which
contains a date. Cell C2 is formatted to display its information as a date.
How do I retain the date formatting of the information contained in cell C2
when it is displayed in cell D4?

The date that is in cell C2 is: 11/1/2006
And the formula that is in cell D4 is: = "'" & C2 & "'"

Cell D4 displays like this: '39022'
But I want cell D4 to display like this: '11/1/2006'

Thank you.

Sincerely,

Corey Foote