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"
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
You saved me from hours of work.
Thank you again.
You are brother,greetings from Hellas