How do you set a numberformat to text?

[Rico Alexander]

I did this with automation by assigning the number format to @ but this doesn''t work with xlio. I''m using vb.net.

[Administrator]

Hi Rico,

Here is the code snippet to set Numberformat to text:

'' Setting NumberFormat to text
sheet.Range("A1:E10").Text = "Number Format"
sheet.Range("A1:E10").NumberFormat = "@"

Please let me know if you have any questions.

Best Regards,
Seetha

>I did this with automation by assigning the number format to @ but this doesn''t work with xlio. I''m using vb.net.