Whats going on with this column display?

Somehow when my macro inserts a timestamp in a cell, it randomly gives me a reveresed date and the time is missing. See attachment,

All cells in the column are left justified, wrap text enabled and are of the Number->Category= DATE type. eg. The format of the field is set correctly and the time is not out of view.... its missing somehow.

also, copying the text time/date from the valid cell above it does display correctly in the weird cell.

any ideas?

I can only suggest to you add the code to format the cell:

Selection.NumberFormat = "dd/mm/yyyy hh:mm:ss AM/PM"

I couldn't reproduce the problem; Copying will copy the format as well so
will get the result you see when you copy from cell above.

"tarns" wrote:

>
> Somehow when my macro inserts a timestamp in a cell, it randomly gives
> me a reveresed date and the time is missing. See attachment,
>
> All cells in the column are left justified, wrap text enabled and are
> of the Number->Category= DATE type. eg. The format of the field is set
> correctly and the time is not out of view.... its missing somehow.
>
> also, copying the text time/date from the valid cell above it does
> display correctly in the weird cell.
>
> any ideas?
>
>
> +-------------------------------------------------------------------+
> |Filename: step1.JPG |
> |Download: http://www.excelforum.com/attachment.php?postid=4444 |
> +-------------------------------------------------------------------+
>
> --
> tarns
> ------------------------------------------------------------------------
> tarns's Profile: http://www.excelforum.com/member.php...o&userid=32291
> View this thread: http://www.excelforum.com/showthread...hreadid=521315
>
>