I am mailmerging from a .txt data source and I want to format the
following number: 00677400

I want it to display 67.74 and that's it.

I can't figure out a way to tailor my field to meet my criteria.
Any ideas?

Use a calculation field eg

{=({Mergefield fieldname} / 10000)}


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




jdawgnat wrote:
I am mailmerging from a .txt data source and I want to format the
following number: 00677400

I want it to display 67.74 and that's it.

I can't figure out a way to tailor my field to meet my criteria.
Any ideas?

When using {=({Mergefield fieldname} / 10000)}

I get a syntax error. Do I have to covert it to a numerical value in
some way before trying to divide it by 100000? It is pulling it from a
..txt file.

- Thanks,

Jonathan

Graham Mayor wrote:
Use a calculation field eg

{=({Mergefield fieldname} / 10000)}


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




jdawgnat wrote:
I am mailmerging from a .txt data source and I want to format the
following number: 00677400

I want it to display 67.74 and that's it.

I can't figure out a way to tailor my field to meet my criteria.
Any ideas?

Did you insert the fields using CTRL+F9 for the field boundaries? You cannot
simply type curly brackets.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




jdawgnat wrote:
When using {=({Mergefield fieldname} / 10000)}

I get a syntax error. Do I have to covert it to a numerical value in
some way before trying to divide it by 100000? It is pulling it from a
.txt file.

- Thanks,

Jonathan

Graham Mayor wrote:
Use a calculation field eg

{=({Mergefield fieldname} / 10000)}


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




jdawgnat wrote:
I am mailmerging from a .txt data source and I want to format the
following number: 00677400

I want it to display 67.74 and that's it.

I can't figure out a way to tailor my field to meet my criteria.
Any ideas?

Yes I did.

You have to substitute 'fieldname' for the name of your field.
It works fine here.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




jdawgnat wrote:
Yes I did.