Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Removing Leading Zeroes
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 |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Removing Leading Zeroes
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing leading whitespace at start of line | Microsoft Word Help | |||
My zip code field on the mail merge drops leading zeroes, why? | Mailmerge | |||
Printing zeroes with line through it | Microsoft Word Help | |||
Mail Merge dropping leading zeroes from the zip code | Mailmerge | |||
Truncating leading zeroes | Microsoft Word Help |