Format numerical value in textbox

Aspose.Cells Product Family
1

Hi,



In the attached MenuWithBackground_Out.xlsx. I would like to have “Texbox 9” with value 1020 to be formatted like “Textbox 7”, or $1,020.00", on “Sheet1.” Is there a way to do this in Aspose.Cells for .NET?



Thanks,



JS

2

Hi,


Thanks for the template file.

Well, in MS Excel, you cannot apply display formatting (for numbers and dates) to a TextBox value. Of Course you may do it for a cell value, see the document for your complete reference:
http://www.aspose.com/docs/display/cellsnet/Setting+Display+Formats+of+Numbers+and+Dates
I am afraid, you have to insert your desired formatted value “$1,020.00” in manual way via Aspose.Cells APIs (e.g via TextBox.Text).

Thank you.