How to format numbers to Accounting format?

[zhangcuiZC]

From issue #80 ,I know how to format numbers to currency , but how do I format them to Accounting format? Thanks!

(pic from #80)

[xuri]

Thanks for your issue. This library not support set Accounting number format currently. I will consider to add this feature later and also welcome to contribute to this project.

[xuri]

Sorry for my so late reply. Excelize support set custom Accounting number format since 4a7495, for example:

f := excelize.NewFile()
if err := f.SetCellValue("Sheet1", "A1", 100); err != nil {
    fmt.Println(err)
    return
}
fmtCode := `_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)`
styleID, err := f.NewStyle(&excelize.Style{CustomNumFmt: &fmtCode})
if err != nil {
    fmt.Println(err)
    return
}
if err := f.SetCellStyle("Sheet1", "A1", "A1", styleID); err != nil {
    fmt.Println(err)
    return
}
// Save spreadsheet by the given path.
if err := f.SaveAs("Book1.xlsx"); err != nil {
    fmt.Println(err)
}

I'll close this issue, if you have any questions, please let me know.