M Milind Sep 13, 2003 #1 In the FileDateTime(filename) command, how to suppress the Time ? Even if column width is shortened, does not help. Milind
In the FileDateTime(filename) command, how to suppress the Time ? Even if column width is shortened, does not help. Milind
T Tom Ogilvy Sep 13, 2003 #2 ' remove the time portion Range("A1").Value = clng(FileDateTime(filename)) Range("A1").NumberFormat = "dd/mm/yyyy" or ' or just format it not to show Range("A1").Value = FiledateTime(filename) Range("A1").NumberFormat = "dd/mm/yyyy"
' remove the time portion Range("A1").Value = clng(FileDateTime(filename)) Range("A1").NumberFormat = "dd/mm/yyyy" or ' or just format it not to show Range("A1").Value = FiledateTime(filename) Range("A1").NumberFormat = "dd/mm/yyyy"
T Tom Ogilvy Sep 14, 2003 #3 Or FIX - negative numbers shouldn't be an issue - good thought. Thanks for the Alert.
