Removing Leading Zeroes

J

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top