| 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 |
| 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) | |||
Hybrid Mode
