Apr 06 2020 06:43 PM
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!
Apr 06 2020 08:56 PM
@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.
Apr 07 2020 10:38 AM
@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!