Display 10 as 10.00???

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

Display 10 as 10.00???

Postby linda.masha » 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

Re: Display 10 as 10.00???

Postby iceblue support » 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: 244
Joined: Tue Dec 21, 2010 2:56 am


Return to Spire.XLS

Who is online

Users browsing this forum: No registered users and 1 guest