Jump to content
You must now use your email address to sign in [click for more info] ×

Recommended Posts

Posted (edited)


Publisher, Data Merge.


Original data are in Excel xlsx, formatted as hungarian phone number: image.png.1b9e71a5cd061886f632c3974ff4c58f.png

When I  merge data in Publisher, it shows the format code, not the number.

(I know, there is an obvious workaround, if I would store the numbers in Excel unformatted, written exactly the characters I would like to see in Publisher. But I think, It should not work like this.)

Why the format code is shown not the number itself?




Edited by Zamek8
Link to comment
Share on other sites

  • Staff

Hi @Zamek8and Welcome to the Forums,

We did have a similar issue logged with the Developers about data merging with formatted text/numbers not being displayed correctly and that was 'fixed' but even the report states, data merging with certain formats will cause trouble for us due a number of reasons.

If you'd like to attach your Excel file and afpub file (before the merge) or upload them to our Dropbox here, I can get it logged to see if this can be improved :) 

Link to comment
Share on other sites

9 hours ago, Zamek8 said:

When I  merge data in Publisher, it shows the format code, not the number.

If you have a list of 'phone numbers like:
 13334444 - code 1 for Budapest
523334444 - code 52 for Debrecen
then the cell format 06-##-###-####
will display them as
in Excel
If you use an xlsx file with Data Merge it will all go wrong but if you use csv then it is fine

Sorry if I misunderstood


Microsoft Windows 10 Home, Intel i7-9750H CPU @ 2.60GHz, 16 GB RAM, 500GB SSD, 1TB Whirlygig, NVIDIA GeForce RTX 2060
Affinity Photo - 24/05/20, Affinity Publisher - 06/12/20, KTM Superduke - 27/09/10

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.