View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bronxbabe bronxbabe is offline
external usenet poster
 
Posts: 19
Default Whole Numbers in Excel with Mail Merge

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,