I have changed the name of the bookmark in case it clashes with a fieldname
your data file. The REF field {oAmount \# "£,0.00"} will display the £ sign.
The rest displays the words.
{ Ask oAmount Amount? }{oAmount \# "£,0.00"} { Set x { oAmount }}{ Set y
{ =INT({ x }) } }{ Set z
{ =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps }
Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " "
" }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence }
If this doesn't work send me the merge document and a small data sample to
the link on the home page of my web site and I'll see if I can spot the
problem
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
Craig wrote:
Sorry for the confusion, it is a document which as some mergefields
as well as fillins and ask, the one I need your help on is not a
mergefield.
I want the document to ask me for an amount? I then enter say 102.53
it then puts the figures in as £102.53 along with the words "One
Hundred and Two Pounds and Fifty Three Pence".
Using the code you gave me it does not show any numbers or text I can
get it to show numbers if i use REF Amount
But the error message "field calculation error occured in record 1"
must relate to your fields as when i remove it the document works fine
Any ideas?
"Graham Mayor" wrote:
You have now lost me. If you are getting the information from a
merge field then why do you need the ask/fillin field?
For mnail merge you need
{ Set x {Mergefield Amount }}{ Set y { =INT({ x }) } }{ Set z
{ =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps }
Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " "
" }" }{ IF { z } 0 "{ z \*Cardtext \*Caps } pence }
where Amount is the fieldname of the number you want as text. It
won't work if the field contains anything other than a number. If
you have a pound sign in the field change that to {Mergefield Amount
\# 0.00}
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
Craig wrote:
please ignore my message re Syntax it was because i have an = sign
in the formula in front of IF.
But on the mail merge there is no text or number and on a separate
document it returns this message, any ideas?
"A field calculation error occurred in record 1."
"Graham Mayor" wrote:
{ Ask Amount Amount? }{ Set x { Amount }}{ Set y { =INT({ x }) }
}{ Set z { =({ x } - { y }) * 100 } }{ IF { y } 0 "{ y
\*Cardtext \*Caps } Pound" }{ IF { y } 1 "s" }{ IF{ y } 0 "{
IF { z } 0 " and " " " }" }{ IF { z } 0 "{ z \*Cardtext
\*Caps } pence }
At the prompt enter 102.53 or whatever.
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
Craig wrote:
I think the problem is i have used ASK field or FILL-IN Field so
it is taking the 102.53 as text not numbers? could this be the
case if so is there a way around this i want the mail merge to
promt me to fill in a number?
"Graham Mayor" wrote:
{ Set x 102.53}{ Set y { =INT({ x }) } }{ Set z { =({ x } - { y
}) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{ IF
{ y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }" }{
IF { z } 0 "{ z \*Cardtext \*Caps } pence }
(watch the spaces and don't use smart quotes) should work. Don't
forget each pair of brackets {} is placed with CTRL+F9
If the bookmark Payment contains only a number ie 102.53 and not
£102.53 then
{ Set x {Payment}}{ Set y { =INT({ x }) } }{ Set z { =({ x } - {
y }) * 100 } }{ IF { y } 0 "{ y \*Cardtext \*Caps } Pound" }{
IF { y } 1 "s" }{ IF{ y } 0 "{ IF { z } 0 " and " " " }"
}{ IF { z } 0 "{ z \*Cardtext \*Caps } pence }
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
Craig wrote:
Sorry could you help me further. I set the word document with a
bookmark named "Payment" it set up to ask me for an amount, for
eample £102.53, I then tried to use your previous link to
convert into words but I couldn't get it to work
Are the x,y,z letters default or is this something i need to set
up in another field??
£ 102.53
{SET x 102.53}{SET y { =INT({x})}}{SET z {
=({x}-{y})*100}}{IF{y}0"{y\*Cardtext} Pound"}{IF{y}1
"s"}{IF{y}0"{IF{z}0" and " " "} "}{IF{z}0 "{z \*Cardtext}
pence"{IF{z}1 "s
"Graham Mayor" wrote:
See http://www.gmayor.com/insert_a_date_...than_today.htm
and in particular the link to Macropod's downloadable document.
For the cash to text see
http://www.gmayor.com/formatting_word_fields.htm and the
section - Formatting cash amounts in words
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
Craig wrote:
Two queries
1) I need to create a furture date in word that is linked to a
merge field.
E.g the merge field i have creates a date, say, 28 February
2009 i then want to create a future date that is 9 months in
the future but the last day of that month i.e 30 November
2009.
I also want to create a future date which is 9 months and one
day, is this possible to do using fields?
2) i need to convert number in to text using merge formating
i.e £105.25 to One Hundred and Five Pounds and Twenty Five
Pence