Okay, I got the money cell in cell formula to work, but now I want to do one
with a date, and can't seem to get the date to show up correctly.

If I just enter the formula in the text string as &(A1) & where A1 is the
date January 7, 2005, I get the numeric value of the date 38359. How do I
switch the format in the calculation? Is there a way to bold is within the
rest of the sentence?

(This is Excel 97...I'll be getting an upgrade to Xp and 2003 in a week...)