|
|
#1
05-09-2023, 01:58 AM
|
|||
|
|||
Setting "dd.mm.yyyy" date format for Excel column doesn't work properly!
Code:
...
Dim fs As Object
Dim fo As Object
Dim strTargetSheet As String
...
Set fs = CreateObject("Excel.Application")
Set fo = fs.Workbooks.Add
fo.Sheets("Sheet1").Name = strTargetSheet
...
fo.Sheets(strTargetSheet).Columns("F").NumberFormat = "dd.mm.yyyy"
...
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Trying to use function =if(isblank(**),"",1) but it doesn't seem to work on the columns Ihave listed | daviddyer2902 | Excel | 1 | 03-06-2023 02:24 AM |
| Change the Column reference 'S' to a range ??? Sheets("Customer").Range("S" & ActiveCell.Row) = Date | trevorc | Excel Programming | 1 | 03-04-2021 02:39 PM |
| "Uppercase" in Master Layout doesn't work in actual slides | BDesign | PowerPoint | 2 | 07-03-2019 07:06 AM |
 Formula to format "I" column based on if "F" column row is not blank
|
ravl13 | Excel | 3 | 08-22-2017 12:26 PM |
|
Why the "table of contents" doesn't take the same format of the "headings"?
|
Jamal NUMAN | Word | 5 | 06-15-2011 10:14 AM |
Windows 8 
Office 2016
Threaded Mode