Decimal point

J

Jason

Hi, I have a merge field that I want formatted so that a
decimal point is inserted in the appropriate place in the
number. The number is usually 260.

Right now my merge field looks like this:
(Field29 is the number 260, but the number sometimes
varies.)

{MERGE FIELD Field29 \# "00.00"}

I want the final outcome to look like this: 2.6 or 2.60.

How do I format the merge field?

I realize there is probably a simple answer to this, but I
have tried many different combos and am stuck.

TIA,
Jason
 
D

Doug Robbins - Word MVP

Hi Jason,

Use

{ = { MERGEFIELD Field29 } / 100 \# "0.00" }

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
 

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