The data starts with a date and the rest of the fields are numbers... like so:
Code: Select all
19/01/2019 51.1 26.43 10.28
When I write the call as String, the date is written as string ('19/01/2019) and not as date.
Code: Select all
' loop through text line array
If i <> 0 then
' write all cells as number
cell.Value = arrCurrentLine(i)
Else
' write first cell as String
cell.String = arrCurrentLine(i)
End If
How can I write the date as a date to the cell?
Any hints appreciated.