We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How do you set a numberformat to text?

Thread ID:

Created:

Updated:

Platform:

Replies:

35860 Oct 12,2005 06:18 AM UTC Oct 12,2005 12:46 PM UTC WinForms 1
loading
Tags: XlsIO
Rico Alexander
Asked On October 12, 2005 06:18 AM UTC

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

Administrator [Syncfusion]
Replied On October 12, 2005 12:46 PM UTC

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.

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;