Currency Formatting - Word 2000

[Chris Stammers]

I need to format a currency field to be £0.00 if greater than £1 and 00p if
less than £1 in the data source. The data source holds the data as 1.00 or
..50. I have created this query: {IF { MERGEFIELD } > 1 "£{MERGEFIELD\#,0.00 }
"{ MERGEFIELD\#.00 }p" }

The query does work but where there is just .50, it shows in the merge doc
with a leading decimal point. My question is this - is there a formatting
switch to get rid of the decimal point in the case where it is just pence? I
have tried taking the decimal point away and the query stops working. I tried
susbtituting the hash sign for a '@' instead and that didn't work either. Any
suggestions?

Thanks,
Chris

 

[Doug Robbins - Word MVP]

Multiply it by 100

{IF { MERGEFIELD } > 1 "£{MERGEFIELD\#,0.00 }
"{ = { MERGEFIELD\#.00 }* 100 }p" }


--
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

 

[Peter Jamieson]

Try

{ IF { MERGEFIELD myamount } > 0.995 "{ MERGEFIELD myamount \#£,0.00 }"
"{ ={ MERGEFIELD myamount } * 100 \#00p }

Peter Jamieson

 

[Chris Stammers]

Peter and Doug - Thank you.
Regards,
Chris

 

[Chris Stammers]

Hello again,

Thanks for this query. I have placed it into 2 documents. It works in one
place in one document. However it seems that when the query is converting to
pence, only part of the paragraph it is part of will generate. The pound
formatting works fine.

However, the other document I have placed it in doesn't work at all if that
query is placed in it; all I get is 'Field Calculation Error in Record 1' etc.

Any ideas?

Thanks,
Chris

 

[Peter Jamieson]

a. I've missed the closing quotes and field brace:

b. It may need quotes around the format, i.e.

{ IF { MERGEFIELD myamount } > 0.995 "{ MERGEFIELD myamount \#"£,0.00" }"
"{ ={ MERGEFIELD myamount } * 100 \#"00p" }" }

If you still have trouble I suppose I would try the following next

{ IF { MERGEFIELD myamount } > 0.995 "{ MERGEFIELD myamount \#"£,0.00" }"
"{ ={ MERGEFIELD myamount } * 100 \#"00" }p" }

Peter Jamieson

 

[Chris Stammers]

Peter,

Many thanks. I have tried both of those options with a basic merge using a
dummy file and both seemed to work fine. I will try with the offending
documents on Monday and see what happens.
Regards,
Chris

 

[Graham Mayor]

Peter,

You may find the macro at http://www.gmayor.com/export_field.htm useful as
it exports the fields intact to a text string which can be pasted into a NG
message, thus avoiding such typos.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Peter Jamieson]

Thanks for the reminder Graham.

Peter Jamieson

Peter,

You may find the macro at http://www.gmayor.com/export_field.htm useful as
it exports the fields intact to a text string which can be pasted into a
NG message, thus avoiding such typos.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>