XLSio Currency Format in cell

[Saurabh Dua]

I am using XLSio but not able to set the format of cell to currency type as to display $4000
It just gives a "file Error: some number formats may have been lost"

Code:

sheet.Range("B3").NumberFormat = "Currency"
sheet.Range("B3").Number = 4000


The code file is also attached herewith as a .zip

code11.zip

[Saurabh Dua]

Searched on the forum and found solution:

sheet.Range("B3").Number = 55250
sheet.Range("B3").NumberFormat = "$#,##0_);($#,##0)"

thanks anyways for making this forum

[Administrator]

Hi Saurabh Dua

Thanks for your interest in XlsIO. Let has know if you have any difficulties in using XlsIO. We promise you a solution with in 24 hours.

With Regards
Chella.