Spire.XLS for .NET is a professional Excel .NET library that can be used to any type of .NET( C#, VB.NET, ASP.NET, .NET Core) application, both ASP.NET web sites and Windows Forms application.

Thu Dec 23, 2010 1:25 am

hi experts,

could you please help me to solve this problem? i know this must be some kind of stupid question but i really want to know where i go wrong.

All I try to do is to display 10 as 10.00
Dim amount As Double = 10
lblAmount.Text = Format(amount, "##,##0.00")

And what I am getting is this:
&10=##,##0.00

Please help...

linda.masha
 
Posts: 5
Joined: Thu Dec 23, 2010 1:17 am

Thu Dec 23, 2010 8:39 am

please try:

amountCell.NumberValue = amount
amountCell.NumberFormat = "#,##0.00"

:P :P :P
e-iceblue support
User avatar

iceblue support
 
Posts: 240
Joined: Tue Dec 21, 2010 2:56 am

Return to Spire.XLS