On Mon, 2 Oct 2006 13:59:42 +0100, "Peter T" <peter_t@discussions
wrote:

Hi Peter,

Are you sure your dateTime is a numeric value and not a string
representation. If you're lucky this might work -

=INT(TRIM(A7))

otherwise post back what you debug with this -
Debug.Print ActiveCell.Value, ActiveCell.Value2

embrace each with quotes to indicate any leading/trailing spaces
also indicate the full cell contents as displayed

Regards,
Peter T

Hi Peter t,

The cell is shown as having a custom format, dd/mm/yyyy hh:mm - if I
format the cell as a number then for the cell entry:

01/10/2006 21:17

I get the following numeric:

38991.8868055556

Not too sure what do do with "Debug.Print ActiveCell.Value,
ActiveCell.Value2" :-(

--
Cheers

Peter

Please remove the invalid to reply