SOLVED

EXCEL FORM WITH DECIMALS PROBLEM

%3CLINGO-SUB%20id%3D%22lingo-sub-2143288%22%20slang%3D%22en-US%22%3EEXCEL%20FORM%20WITH%20DECIMALS%20PROBLEM%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2143288%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20afternoon%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAt%20the%20attached%20file%20you%20will%20find%20my%20problem%20with%20decimals.%3C%2FP%3E%3CP%3EIf%20someone%20can%20help%20i%20will%20be%20obliged.%3C%2FP%3E%3CP%3EThanks%20eneryone%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2143288%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New 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 (New 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