Field code to display numbers and text

[Earl]

I want to display both number and text in a word document using an excel file
as my database.

The data is mostly numeric "0.041" but some are "<0.010", the latter
displays as 0.00 when I apply a field code of ......\# "0.000" to round
numbers to three decimal places.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?RWFybA==?=,

I want to display both number and text in a word document using an excel file
as my database.

The data is mostly numeric "0.041" but some are "<0.010", the latter
displays as 0.00 when I apply a field code of ......\# "0.000" to round
numbers to three decimal places.

Are you talking about mail merge? In which version of Office?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[Earl]

It's mailmerge and I'm using XP Pro

Hi =?Utf-8?B?RWFybA==?=,

Are you talking about mail merge? In which version of Office?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)


This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?RWFybA==?=,

It's mailmerge and I'm using XP Pro

Right. For the future, the best place to get a quick response is the mail merge /
fields newsgroup

This is a factor of how the connection method is pulling the information out of
Excel. It basically doesn't like "mixed" data types. Since it's getting very
difficult to use a DDE connection, these days, your only recourse is to tell Excel
all the data should be interpreted, literally, as text. You have to do this through
the DATA menu (just formatting the cell isn't good enough).

Select the column in question. Data/Text to columns. In the third step you can
specify "Text" as the data type.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply in
the newsgroup and not by e-mail