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