Forum Discussion
Solved
EXCEL FORM WITH DECIMALS PROBLEM
Good afternoon everyone,
At the attached file you will find my problem with decimals.
If someone can help i will be obliged.
Thanks eneryone in advance.
Using a formula: enter the following in E5:
=ROUND(C5,0)
and fill down.
If you want to display the values in column C the way you want, set the number format of C5:C7 to the custom format
0".000"
2 Replies
Using a formula: enter the following in E5:
=ROUND(C5,0)
and fill down.
If you want to display the values in column C the way you want, set the number format of C5:C7 to the custom format
0".000"
- Thank you very much dear Hans,
You saved me from hours of work.
Thank you again.
You are brother,greetings from Hellas
