Prevent Excel to format string as date

Question

I want to insert a string of type `10/3` in a cell like this: ``` Worksheets("Sheet1").Range("A1").Value = "10/3" ``` But Excel automatically formats the cell as a date or a number. I want to have it as a string. How can I achieve this with VBA?

Accepted Answer

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

Prevent Excel to format string as date

Solution

Problem