I have an excel file with numeric data. The data need to be formatted as per accounting policies of my company.
The custom format of file is
“mso-number-format:#,##0.####_);[Red](#,##0.####)”.
It provides correct results for numeric data which has decimal values.
However, if the data is numeric e.g. 4, it formats the data as “4.” i.e. with a dot at the end.
We do not want the dot(or decimal) at the end, as the data is already an integer.
Please suggest a solution or a workaround.
Thanks
Dushyant
