connecting users of the CorelDRAW family of products

Data merge issue with numbers using xls file

rated by 0 users
Answered (Verified) This post has 1 verified answer | 9 Replies | 1 Follower

Share  
Page 1 of 1 (10 items) | RSS

signs2u posted on Sat, Nov 10 2012 0:55

Answered (Verified) Verified Answer

Top 50 Contributor
Wisconsin
Male
Verified by signs2u

It sounds like what is needed is for the numeric fields to be treated simply as text.  This is also a formatting setting in Excel. The end result should be that in the delimited file the numbers are enclosed in quotes. 

Hope it helps

Art for a crowded planet - your window to my art and life online

Making images of balance and harmony for a chaotic world.

All Replies

Top 75 Contributor
Mumbai, INDIA
Male
CorelDRAWMaster

Hello,

Your post is not visible. Looks like you posted using Internet Explorer. Re-post using browser other than IE; Google Chrome or Firefox may be?

CorelDRAW Graphics Suite X7
Tabbed Interface, Transparency in Fountain Fills, Content Exchange

www.corelinsight.com

try again - IE didnt post question ...

Using xls spreadsheet for data merge

Contains text and numeric fields;

The numeric data is merging with trailing .00

ie 1 is merging as 1.0 20 is merging as 20.00000

 

XLS formatting for the numbers was general - also tried - number with decimal places set to 0

 

thanks  

 

Top 25 Contributor
Pune, India
Male
CorelDRAWMaster

Try formatting the cell as required in Excel. Then export the Excel file to .CSV format or .TXT (Tab Delimited) format and use it to merge the data.

thanks = yes have tried the formatting both xls and csv files give the trailing .000s

 

Top 25 Contributor
Pune, India
Male
CorelDRAWMaster

Trailing 00's are the result of formatting of cells set in Excel. Check the settings in Excel under Format > Cells > Numbers and remove the settings for trailing 0's and then save the file to use it in DRAW.

signs2u:
yes have tried the formatting both xls and csv files give the trailing .000s

Thanks but as above 

Format in  excel - is correct - no decimal places

but all numbers merged leave varying trailing .00 ie some are 0 others are .00000

 

Top 50 Contributor
Wisconsin
Male
Verified by signs2u

It sounds like what is needed is for the numeric fields to be treated simply as text.  This is also a formatting setting in Excel. The end result should be that in the delimited file the numbers are enclosed in quotes. 

Hope it helps

Art for a crowded planet - your window to my art and life online

Making images of balance and harmony for a chaotic world.

text works - any numeric formatting does not... Go figure

Use merge alot not had this issue before.

Many thanks for the help

Top 50 Contributor
Wisconsin
Male

Glad you got it working.

Art for a crowded planet - your window to my art and life online

Making images of balance and harmony for a chaotic world.

Page 1 of 1 (10 items) | RSS
© Corel Corporation. The content herein is in the form of a personal web log ("Blog") or forum posting. As such, the views expressed in this site are those of the participants and do not necessarily reflect the views of Corel Corporation, or its affiliates and their respective officers, directors, employees and agents. Terms and Conditions / User Guidelines.