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