How to suppress Time ?

M

Milind

In the FileDateTime(filename) command, how to suppress the Time ? Even if
column width is shortened, does not help.

Milind
 
T

Tom Ogilvy

' 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

Or FIX - negative numbers shouldn't be an issue - good thought. Thanks for
the Alert.
 
Top