Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to suppress Time ?
In the FileDateTime(filename) command, how to suppress the Time ? Even if
column width is shortened, does not help. Milind --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.514 / Virus Database: 312 - Release Date: 8/28/2003 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to suppress Time ?
' 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" -- Regards, Tom Ogilvy Milind wrote in message ... In the FileDateTime(filename) command, how to suppress the Time ? Even if column width is shortened, does not help. Milind --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.514 / Virus Database: 312 - Release Date: 8/28/2003 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to suppress Time ?
Or FIX - negative numbers shouldn't be an issue - good thought. Thanks for
the Alert. -- Regards, Tom Ogilvy Rob Bovey wrote in message ... "Tom Ogilvy" wrote in message ... ' remove the time portion Range("A1").Value = clng(FileDateTime(filename)) Range("A1").NumberFormat = "dd/mm/yyyy" I'd be careful with CLng(), since it rounds. Int() would probably be better. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Suppress PopUp | Excel Discussion (Misc queries) | |||
Suppress @VALUE! on a template. | Excel Discussion (Misc queries) | |||
How do I suppress the time in m/d/yy date column? | Excel Discussion (Misc queries) | |||
Suppress a row | Excel Worksheet Functions | |||
#DIV/0! ...how to suppress when using this formula.... | Excel Discussion (Misc queries) |