Forum Discussion

cmoran's avatar
cmoran
Copper Contributor
Apr 07, 2020

Need to remove the numbers after the decimal.

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!

excel

3 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Apr 07, 2020

    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.

Resources