Re: Word is adding zeros in front of numbers

Hi Anne.
My goal is for the merged data to appear as numbers that look something like
2,300, 75, etc. The dilemma is that, thus far, I have not been able to
achieve that outcome using switch codes - it seems that I must sacrifice one
of three things. First, when using a switch code "\#0" I can obtain the
desired effect, but no commas are present. If I use "\#,#" then mergefields
for which the data source reports a zero are ommitted in the merged document.
If I use "\#0 #,#" then no commas appear. If I modify slightly by "\#0#,#" I
get my zeros and commas, but data in the MSExcel document that are the
product of a formula, e.g. "=sum(A1:A4)" AND are less than three digits, e.g.
45, are presented as "045."

Thus far, I have not been able to find the right combination of switches
that will give me: commas, viewable data-source zero-value-entries, AND
properly formatted merge results, e.g. 45, that is the product of a formula
in the source document. I simply don't know what other switches or solutions
might be available. Thank you for any assistance or solution you might be
able to provide.

Nat

If I want the commas then I have to accept numbers like "075."
Alternatively, I can get the number to look like "75" but then I can't get
the commas. And yet another alternative, I can indeed get the commas and the
two digit numbers looking right, but I will lose other merged values for
which a zero is entered in the spread***.

I am using an MSExcel file as the source document and merging to an MSWrod
document. The situation occurs for a couple of cells, all with the same
structure. First, the MSExcel content is the result of a formula, e.g.
"=sum(s3:s9)."

Second, result of the formula is a two digit number, e.g. 59. When the
number is three digits there is no problem. In the MSWord document, an
example of a problematic merge field (when viewed with the F9 toggle) is {
MERGEFIELD "Total_Revenue" }. The result looks something like "059." I have
tried a couple of switches in hopes of getting the appearance I want but can
never get every thing I want. For example, { MERGEFIELD "Total_Revenue" \#0
} gives "59," but when I try to include a switch that will format using
commas in larger numbers { MERGEFIELD "Total_Revenue" \#0 #,#} it goes back
to "059."

solutions but I have not been able to get the

"Anne Troy" wrote:

> Okay, Nat. So what does your merge field look like when you view it? Also,
> what's the cell format in Excel?
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
>
>
> "Nat" <Nat@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:23EEFB81-DA0F-43A7-96E7-520BB6B2930C@xxxxxxxxxxxxxxxx
> > Thank you for the response Anne, but it doesn't quite get at my problem.
> My
> > problem is that the merge feature is ADDING a zero in fron of some
> numbers -
> > not dropping them. I think that I could include a switch that limits the
> > number of digits to the LEFT of a decimal point - thus eliminating the
> zero,
> > but this will not allow that merged item to include three digit numbers
> when
> > needed. What I need is a solution to get RID of a leading zero - not add
> > leading zeros. Thanks
> >
> > "Anne Troy" wrote:
> >
> > > This may help, Nat:
> > >
> http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm
> > > *******************
> > > ~Anne Troy
> > >
> > > www.OfficeArticles.com
> > >
> > >
> > > "Nat" <Nat@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > > news:A7AE0BE9-14EA-4FB6-BB0A-52196FC256F9@xxxxxxxxxxxxxxxx
> > > > I have Office 2003 and am attempting to merge MSExcel data into a Word
> > > > document. I have been working through the problems associated with
> > > formats,
> > > > however, there is one that I can't seem to resolve. Sometimes the
> merged
> > > > numerics that appear in MSWord have a zero in front of the number,
> e.g.
> > > 056
> > > > or -078. This only occurs when the actual number in the Excel
> spread***
> > > is
> > > > less than 100 and also only seems to occur when the data in Excel is
> the
> > > > result of a formula, e.g. "=A3+B3". When data is merely entered as a
> > > numeric
> > > > value, e.g. 57, it appears as 57 in Word, not 057. Suggestions would
> be
> > > > helpful. Thank you
> > >
> > >
> > >
>
>
>
.