3 Replies Latest reply: Jan 29, 2013 12:53 PM by Jeff Shenk
dagmarjo Level 1 Level 1 (0 points)

I have a simple Numbers file with data to merge into a Pages letter. Everything works perfectly except for the last field. The last field is a total of several dollar amounts in the same row. I have it formatted as currency in Numbers. I have event formatted the table cell in Pages to format numbers in that cell as currency. But when I run the mail merge, that last number is displayed as a generic number (no preceding $ and no trailing .00). I found somewhere else in these discussion boards that there was a problem with date functions. Does the mail merge also have problems with simple SUM functions? Anyone know how to get around this without me having to manually enter all of the totals in my Numbers doc? Thanks in advance for your help!


MacBook Pro (15-inch Mid 2010), Mac OS X (10.7.5)
  • 1. Re: Why does a mail merge from Numbers to Pages change the number format of my data?
    Yellowbox Level 5 Level 5 (4,565 points)

    Merge is putting a formula (SUM) into Pages. In Numbers, convert to values (Copy, then Edit > Paste Values).

     

    That will replace the formulas, so do it on a spare copy of your Numbers document (or a spare copy of the table).

     

    Or, add another column to your Numbers table and Paste Values into that. Use that column as your merge source.

     

    Ian.

  • 2. Re: Why does a mail merge from Numbers to Pages change the number format of my data?
    dagmarjo Level 1 Level 1 (0 points)

    Thanks, Yellowbox. I tried your suggestion, and was very optimstic about it, but got the same results. I tried it in a new spreadsheet, in a new column in the current spreadsheet (with and without the column of sum functions included), to no avail. Thanks for the suggestion.

  • 3. Re: Why does a mail merge from Numbers to Pages change the number format of my data?
    Jeff Shenk Level 4 Level 4 (2,115 points)

    I doubt if there is anything wrong with your Numbers document.

     

    I've tried to duplicate you problem and have been completely unsuccessful. Mail Merge will accept a SUM in a Numbers cell which is formatted as currency and enter it into the Pages document as it displays in Numbers. this actually worked for me with currency values entered directly and with ones derived from a calculation. It worked when merging into regular text in Pages and when merging into a cell in a Pages table. The only way I could get it to display as an integer, without the dollar sign and the decimal part was when I merged into a cell of a table that was explicitly formatted as a number with no decimal places.

     

    So, I think it is a problem in your Pages document. What happens if you make a new, blank word processing document, link it to your Numbers document and insert, into the main text body, nothing but a merge field to your SUM field in the Numbers document? Does a merge still change the formatting?