Weird thing happening with dates in 2003

  • Thread starter Thread starter Nit_Wit_400
  • Start date Start date
N

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?
 
Hi

You have to turn the datevalue into text:

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

Regards,
Per
 
Back
Top