I am using ClosedXML to create an Excel file. The issue is I am having amount value in string variable and I want to display it with comma separate number format (like Indian currency culture). Having below mentioned different values.
string v = "89977.600"; ->output : 89,977.600 string v = "16839.20"; ->output : 16,839.20 string v = "10000.00"; ->output : 10,000.00 string v = "68000.02"; ->output : 68,000.02 string v = "0"; ->output : 0 string v = "0.00"; ->output : 0 string v = "0.000"; ->output : 0 string v = "0.000"; ->output : 0 How is it possible in Excel? We can save value as string also.