Reputation: 1
I want to write data in csv file using vb.net.
So before writing the data i want to format the cell to text.
how to do this?
Upvotes: 0
Views: 1324
Reputation: 7076
If you store it as ="1110123.2101008210" excel will store it as text. Make sure not to leave any space preceding the equals sign.
for example: "data",="1110123.2101008210","more data"
Upvotes: 1
Reputation: 1944
you can try object.ToString() or Ctype(object, String)
Replace object with the thing you want to write, i.e. the variable.
Upvotes: 0