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

Daniel,

You can formate it in the formula:

= TEXT('Contract variables'!B12, "mm/dd/yy") & " on " & text('Contract
variables'!B11,"hh:mm:ss") & " at the inspection site"
--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"Daniel" wrote in message
...
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

I've never used the text() function before. Thank you for making me aware of
it!

Daniel P




"Earl Kiosterud" wrote:

Daniel,

You can formate it in the formula:

= TEXT('Contract variables'!B12, "mm/dd/yy") & " on " & text('Contract
variables'!B11,"hh:mm:ss") & " at the inspection site"
--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"Daniel" wrote in message
...
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