Excel format Numeric Data

By Dushy_ant ·
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

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.


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Can't be done using just number format

by paulha In reply to Excel format Numeric Data

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?

Related Discussions

Related Forums