=DATE(INT(A1*24),MINUTE(A1),SECOND(A1))
--
David Biddulph

"Nigel" wrote in message
...
Please could someone assist.

I have some data submitted to me, which on the screen is displayed as
1926:04:12 (which is the year:month:date), though excel is holding the
data
as a time field, in the background which is 20/03/1900 06:04:12.

How do i capture the true data, I have tried various format changes,
though
excel believes its the time i am changing not the values which i am seeing
on
the screen.

any help would be appreciated.