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: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Cell format problem

Thread ID:





99960 Jun 23,2011 12:01 AM UTC Jun 29,2011 06:35 AM UTC ASP.NET Web Forms (Classic) 3
Tags: XlsIO
Asked On June 23, 2011 12:01 AM UTC

Hi All,

In excel, i can apply formula [Red] #,##0 for number,
then the number will have format and color.

can we apply this format onto text and data value as well?


John Bowlin Bosco K [Syncfusion]
Replied On June 23, 2011 07:17 AM UTC

Hi Shrimpy,

Thank you very much for your interest in Syncfusion Products.

To format the cell value, conditional formatting can be used by which the contents of a cell are dynamically formatted, based on a value. To illustrate this, we have created a sample in which the cell value containing "0" is formatted with font color as red and the sample has been attached below. Could you please try the sample and let us know if this helps you.

Sample Link:

Also, please navigate to the attached documentation link to know more about the conditional formatting.


Please let us know if you need any further assistance.

Pauline Bosco

Replied On June 28, 2011 08:12 AM UTC

Hi John ,

Great thanks for you reply.

It is not what i want. but still help.
but basicly the numberformat can apply to any type of values
this is what i tried it out.

still thank you for your help.

Sridhar [Syncfusion]
Replied On June 29, 2011 06:35 AM UTC

Hi Shrimpy,

Thank you very much for the update.

In Essential XlsIO we are supporting all the numberformats to the spcified type values as same as in MSExcel.

Please go through the following online documentation link for more deatails on Number Formatting.


Could you please let us know your actual requirement in applying the number formats so that we can able to sory out easily. Please update the sample for the same if you have any concerns.

Please let us know if you have any futher clarifications.



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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

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