T
tarns
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 |
+-------------------------------------------------------------------+
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 |
+-------------------------------------------------------------------+