Hi,
I would like to know how to convert a number so that it looks like this: "1.175.575,40"
I tried "#,##0.00" and also "#.##0.00"
Both ways come out:
"1,175,575.40"
I need the comma in the decimal places on the right
Grateful,
Guiherme
Workbook workbook = new Workbook();
CellRange range = workbook.Worksheets[0]["A1"];
range.Value = "1175575.40";
range.NumberFormat = "#,###.00";
range.Formula = "SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(\"" +range.NumberText + "\",\".\",\"*\"),\",\",\".\"),\"*\",\",\")";
range.NumberFormat = "general";
//Save the result file
workbook.SaveToFile("NumberFormat.xlsx", FileFormat.Version2013);