Whole Numbers in Excel with Mail Merge

B

bronxbabe

I'm running a mail merge. In excel, my numbers are displaying in the cell as
"2", but in the formula area, it's displayed as 2.15342465753425. I would
like it to merge as the whole number 2. Also, my salaries, in the cell are
displayed as $115,000.00, but above in the formula area, it's displaying as
115000. When the merge is run, I would also like those salary numbers to
generate with the dollar sign and comma separator. How can these two number
issues be corrected, if possible.

Thanks in advance,
 
D

David Biddulph

Use the TEXT() function.
Something like =TEXT(D6,"#") for your first example, and =TEXT(D7,"$#0.00")
for youe second. Adjust the format arguments to suit.
 
Top