[JERRY]

I have a long table, one column of which contains three-digit numbers, one
per cell (the table uses Mail Merge data from an Access database). Is there a
way to remove the leading zeroes from this column without doing it manually?
I'm using Word 2000.
Thanks, Jerry

[macropod]

Hi Jerry,

Since you're using mailmerge, the best way to eliminate the leading 0s, assuming you can't change the data source, is to trim the
values during the merge process. To do this:
.. Select the mailmerge field that's retrieving the values (eg '«Data_Val»').
.. Press Shift-F9 to expose the filed code. It should look something like '{ MERGEFIELD Data_Val }'
.. Edit the field so that you've got '{ MERGEFIELD Data_Val \# 0}'
.. Press Shift-F9 to hide the field code
.. Run your mailmerge.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Jerry" wrote in message ...
I have a long table, one column of which contains three-digit numbers, one
per cell (the table uses Mail Merge data from an Access database). Is there a
way to remove the leading zeroes from this column without doing it manually?
I'm using Word 2000.
Thanks, Jerry