SOLVED

EXCEL FORM WITH DECIMALS PROBLEM

Copper Contributor

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.

2 Replies
best response confirmed by Chrispro1974 (Copper Contributor)
Solution

@Chrispro1974 

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
1 best response

Accepted Solutions
best response confirmed by Chrispro1974 (Copper Contributor)
Solution

@Chrispro1974 

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"

View solution in original post