Forum Discussion
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 on...
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!
cmoran You are welcome!