View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Joergen Bondesen Joergen Bondesen is offline
external usenet poster
 
Posts: 13
Default 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