Remove the leading zero from mergefield .
Hi Dough
Your reply maked med happy, but a test in XP shows:
Input: 09812340078901230067
Output 9812340078901200000
The leading Zero is removed but trailing 230067 = 200000
Does Word have a limitation of 14 / 15 digits?
--
Best Regards
Joergen Bondesen
"Doug Robbins - Word MVP" wrote in message
...
Put the mergefield in a formula that mulitplies it by 1
{ = { MERGEFIELD fieldname } * 1 }
You must use Ctrl+F9 to insert the field delimiters { }
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"Joergen Bondesen" wrote in message
...
Hi NG.
I have a mailmerge field where the field from a txt-file display 20
digits: '09812340078901230067'
I want only displayed 19 digits '9812340078901230067' because zero may
not be displayed.
It is not posssible to remove the leading zero in the txt-file.
-----
Best Regards from
Joergen Bondesen
|