Prevent Excel to format string as date

Worksheets("Sheet1").Range("A1").NumberFormat = "@"
Worksheets("Sheet1").Range("A1").Value = "10/3"

add a single quote ' before the value - in your example, it would make the line

Worksheets("Sheet1").Range("A1").Value = "'10/3"

or, if you have a variable that holds the data

Worksheets("Sheet1").Range("A1").Value = "'" & MyValue

Related