Hi.
How can I convert text columns into number
I’m using this macro for formating column E
Sub macro()
[E:E].Select
With Selection
.NumberFormat = “#,###0.00”
.Value = .Value
End Withend sub
and it is formated well, but just after clicking excel cell.
How can I force data table to format text data to number when writing to excel?