[Craig]

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

[Graham Mayor]

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

[Craig]

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

[Graham Mayor]

{ 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

[Craig]

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

[Graham Mayor]

{ 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