Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to display the column or cell the MIN() result came from? | Excel Worksheet Functions | |||
how can i multiply two columns | Excel Worksheet Functions | |||
display last cell in a column as the sheet is updated | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions |