I have the following two formulas on which I have a formatting problem:-

="Sales Record No."&" "&SalesHistory.csv!$A$4

I would like the words Sales Record No. to be in bold.

="Date Ordered:"&" "&SalesHistory.csv!$Y$4

The date on this formula is appearing as the serial to the date. (39994)

I know I could just put the formula field in a seperate cell, but it makes the layout a little more difficult.

macke