Software

Ask something
Question Locked

Excel format Numeric Data

0 helpful
2 replies

by dushy_ant

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

2 replies

by paulha

Excel can't tell automatically if the cell value is an integer, which is why it leaves in the trailing decimal point. You could use a VBA workaround to detect this, or use formulae to work around it.

Would this be an acceptable workaround?

This discussion is closed to new replies.