Hi all,
Is there possible by using VBA to convert to number to at least 2 decimal places if the original number is an integer or only 1 decimal place and remain unchanged if more than 2 decimal places.
Some Example:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Thank a lot.
Is there possible by using VBA to convert to number to at least 2 decimal places if the original number is an integer or only 1 decimal place and remain unchanged if more than 2 decimal places.
Some Example:
Before | After | |
10.99 | 10.99 | |
15 | 15.00 | |
65.777 | 65.777 | |
187.3 | 187.30 | |
123.3686 | 123.3686 | |
70 | 70.00 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Thank a lot.