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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Suppress warning message 2
Suppressing questions in Excel Macros 1
How to set time within macro? 1
Move all except latest to another folder 2
How to set time for processing the code? 4
Formatting question: how to format duration (time spent)? 0
how to suppress auto correct? 1
VBA--Suppress error message,corrupt file or unrecognizable format 6

Top