Hello,

I am building a text using multiple cell values. Here is an extract

= 'Contract variables'!B12 & " on " & 'Contract variables'!B11 & " at the
inspection site"

problem being that it return/displays

'0.375 on 39294 at the inspection site'

instead of

'9:00 on 2007/07/29 at the inspection site'

How can I convert the date and time values into proper values?

Thank you,

Daniel P