Weird thing happening with dates in 2003

[Nit_Wit_400]

I'm using Excel for a merge database. On sheet 1, I have cells that
format dates to be e.g. July 6, 2009. On Sheet 2, I have that cell
from Sheet 1 included in a sentence. So... in Sheeet 2, B1="Recorded
on "&Sheet1!B29 | Sheet1 B29 being the date I mentioned.

I'm getting in my output: "Recorded on 4000" which is really uncool
because I'm doing this A LOT in my document.

Please help?

 

[Pete_UK]

Do it this way:

="Recorded on "&TEXT(Sheet1!B29,"mmmm d, yyyy")

Hope this helps.

Pete

 

[Per Jessen]

Hi

You have to turn the datevalue into text:

= "Recorded on " & TEXT(Sheet1!B29,"mmm d, yyyy")

Regards,
Per

 

[Nit_Wit_400]

Works great! Thanks so much