Question

Locked

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
"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

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| 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?

Back to Software Forum
1 total post (Page 1 of 1)  

Related Forums