sheron
sheron

Reputation: 1

formatting csv file before writing

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

Answers (2)

Craig
Craig

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

Justin Largey
Justin Largey

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

Related Questions