Re: Word is adding zeros in front of numbers

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
> >
> >
> >


.

Loading