Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

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