Thread: [Solved] Correct Format needed
View Single Post
 
Old 05-02-2011, 05:44 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,363
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Tony,

That suggests you have the street Nos in their own field/column. If so, what's happening is that Word has looked at the first 10-15 rows of data and determined that the data are numeric. Consequently, when it gets to a field with alpha characters, it evaluates it as 0, numerically. You can probably resolve the matter by changing your data sort order so that the alpha-numeric addresses are at the top of the list. Alternatively, you could add some rows of dummy data, then exclude them from the merge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote