Re: Retaining date formatting in referencing cell

Giganews Newsgroups
Subject: Re: Retaining date formatting in referencing cell
Posted by:  David Biddulph (groups [at] biddulph.org.uk)
Date: Wed, 22 Aug 2007

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

--
David Biddulph

"Corey Foote" <Corey Foo…@discussions.microsoft.com> wrote in message
news:F937C863-E788-4753-9DD2-CCAA18C7FE…@microsoft.com...
> 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

Replies

None

In response to

Retaining date formatting in referencing cell posted by Corey Foote on Wed, 22 Aug 2007