|Subject:||RE: Retaining date formatting in referencing cell|
|Posted by:||Teethless mama|
|Date:||Wed, 22 Aug 2007|
"Corey Foote" wrote:
> 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.
> Corey Foote
Retaining date formatting in referencing cell posted by Corey Foote on Wed, 22 Aug 2007