ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Whats going on with this column display? (https://www.excelbanter.com/excel-discussion-misc-queries/76647-whats-going-column-display.html)

tarns

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?


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


Toppers

Whats going on with this column display?
 
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




All times are GMT +1. The time now is 11:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com