MarioVee Posted April 3, 2023 Posted April 3, 2023 (edited) When trying to insert data fields from an xlsx I made, the month values are not being recognized correctly. The other fields seem to work fine, any ideas how to fix? Trying to split up the month portion for better formatting in my document. Edited April 3, 2023 by MarioVee Quote
Old Bruce Posted April 4, 2023 Posted April 4, 2023 The problem is using a formula for the Month field. You could export the Excel file as a CSV file and use that in the Data Merge. Or you could perhaps force the formula to use the actual word instead. Quote Mac Pro (Late 2013) Mac OS 12.7.6 Affinity Designer 2.6.0 | Affinity Photo 2.6.0 | Affinity Publisher 2.6.0 | Beta versions as they appear. I have never mastered color management, period, so I cannot help with that.
MarioVee Posted April 6, 2023 Author Posted April 6, 2023 Thank you, I'll try exporting as a CSV and use that. Quote
Recommended Posts
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.