Need to remove the numbers after the decimal.

%3CLINGO-SUB%20id%3D%22lingo-sub-1286938%22%20slang%3D%22en-US%22%3ENeed%20to%20remove%20the%20numbers%20after%20the%20decimal.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1286938%22%20slang%3D%22en-US%22%3E%3CP%3EEx.%20My%20cell%20shows%20%24585.93%2C%20but%20when%20I%20click%20on%20the%20cell%20the%20formula%20bar%20shows%20585.935265624861%26nbsp%3B%20When%20I%20complete%20a%20mail%20merge%2C%20the%20latter%20number%20shows%20up%20after%20the%20merge%20so%20I%20have%20to%20make%20revisions%20once%20merged.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1286938%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1287132%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20to%20remove%20the%20numbers%20after%20the%20decimal.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1287132%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F611818%22%20target%3D%22_blank%22%3E%40cmoran%3C%2FA%3E%26nbsp%3BI%20suspect%20that%20you%20didn't%20enter%20the%20value%20yourself%2C%20but%20that%20it%20comes%20from%20a%20copy%2Fpaste%20action%20or%20an%20import%20of%20some%20kind.%20Formatting%20the%20number%20to%20show%20only%20two%20decimals%2C%20does%20not%20change%20the%20number%20itself.%20You%20need%20to%20round%20it%20first.%20Try%20inserting%20a%20column%20and%20enter%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DROUND(%3CCELL%3E%2C2)%3C%2FCELL%3E%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E....%20and%20then%20pick-up%20that%20field%20in%20Mail%20Merge.%20If%20you%20don't%20want%20to%20(or%20need%20to)%20keep%20the%20original%20number%2C%20you%20can%20copy%20the%20rounded%20numbers%20and%20paste%20them%20as%20values%20on%20to%20the%20original%20numbers.%20Then%20delete%20the%20column%20that%20holds%20the%20formula%20above.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1289251%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20to%20remove%20the%20numbers%20after%20the%20decimal.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1289251%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%20That%20worked!%26nbsp%3B%20Appreciate%20your%20help!%26nbsp%3B%20You're%20right%20that%20the%20spreadsheet%20was%20created%20by%20someone%20else.%26nbsp%3B%20I%20copied%20and%20pasted%20the%20values.%20Thanks%20again!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Ex. My cell shows $585.93, but when I click on the cell the formula bar shows 585.935265624861  When I complete a mail merge, the latter number shows up after the merge so I have to make revisions once merged.

 

Thanks!

3 Replies
Highlighted

@cmoran I suspect that you didn't enter the value yourself, but that it comes from a copy/paste action or an import of some kind. Formatting the number to show only two decimals, does not change the number itself. You need to round it first. Try inserting a column and enter

=ROUND(<cell>,2)

.... and then pick-up that field in Mail Merge. If you don't want to (or need to) keep the original number, you can copy the rounded numbers and paste them as values on to the original numbers. Then delete the column that holds the formula above.

@Riny_van_Eekelen  That worked!  Appreciate your help!  You're right that the spreadsheet was created by someone else.  I copied and pasted the values. Thanks again!

Highlighted

@cmoran You are welcome!