Re: Word is adding zeros in front of numbers

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