Convert Numerals to Words

[Fuzzy]

Is there any formula that i can use in a word document that would
automatically convert a number to its corresponding value in "words" ??

 

[Pesach Shelnitz]

Hi,

The QUOTE field with the \*CardText switch does this. For example, to
convert the number 1234 to words, insert a field, select QUOTE, and enter the
following code:
QUOTE \*CartText "1234"

 

[Fuzzy]

Thanks a ton, for the formula...
but I'm a new word user....

would you please tell me, how do i go about using this in word..

supposing the text is:

The customer Mr A has paid an amount of USD 100 (USD One Hundred Only) today.

how do i get the One Hundred there???

after 100 i just type QUOTE \*CartText "1234"


????

Sorry...

 

[macropod]

Hi Fuzzy,

Press Ctrl-F9 to create a pair of field braces (ie '{}')
Between the field braces, type '=1234 \* CardText' so that you end up with {=1234 \* CardText }
Select the field and press F9.

The output will be in lower case. You can change the case by adding another switch, eg:
{=1234 \* CardText \* Upper} - upper case
{=1234 \* CardText \* Caps} - title case
{=1234 \* CardText \* FirstCap} - sentence case

 

[Fuzzy]

aaaaaaaaaaaaaaaaahh!!

I LOVE YOU!!!

Thanks a million!!!! It worked!

Hi Fuzzy,

Press Ctrl-F9 to create a pair of field braces (ie '{}')
Between the field braces, type '=1234 \* CardText' so that you end up with {=1234 \* CardText }
Select the field and press F9.

The output will be in lower case. You can change the case by adding another switch, eg:
{=1234 \* CardText \* Upper} - upper case
{=1234 \* CardText \* Caps} - title case
{=1234 \* CardText \* FirstCap} - sentence case

--
Cheers
macropod
[Microsoft MVP - Word]

Thanks a ton, for the formula...
but I'm a new word user....

would you please tell me, how do i go about using this in word..

supposing the text is:

The customer Mr A has paid an amount of USD 100 (USD One Hundred Only) today.

how do i get the One Hundred there???

after 100 i just type QUOTE \*CartText "1234"


????

Sorry...

 

[Fuzzy]

ok sorry - one more doubt....

if i have a decimal number, how can i get the numbers after the decimal also
to get converted into text?

instead of cardtext, i tried dollar text and it read the number as 45/100
instead of and forty five

Hi Fuzzy,

Press Ctrl-F9 to create a pair of field braces (ie '{}')
Between the field braces, type '=1234 \* CardText' so that you end up with {=1234 \* CardText }
Select the field and press F9.

The output will be in lower case. You can change the case by adding another switch, eg:
{=1234 \* CardText \* Upper} - upper case
{=1234 \* CardText \* Caps} - title case
{=1234 \* CardText \* FirstCap} - sentence case

--
Cheers
macropod
[Microsoft MVP - Word]

Thanks a ton, for the formula...
but I'm a new word user....

would you please tell me, how do i go about using this in word..

supposing the text is:

The customer Mr A has paid an amount of USD 100 (USD One Hundred Only) today.

how do i get the One Hundred there???

after 100 i just type QUOTE \*CartText "1234"


????

Sorry...

 

[Fuzzy]

this formula does not work for numbers greater than 999,999
why is that?

ok sorry - one more doubt....

if i have a decimal number, how can i get the numbers after the decimal also
to get converted into text?

instead of cardtext, i tried dollar text and it read the number as 45/100
instead of and forty five

Hi Fuzzy,

Press Ctrl-F9 to create a pair of field braces (ie '{}')
Between the field braces, type '=1234 \* CardText' so that you end up with {=1234 \* CardText }
Select the field and press F9.

The output will be in lower case. You can change the case by adding another switch, eg:
{=1234 \* CardText \* Upper} - upper case
{=1234 \* CardText \* Caps} - title case
{=1234 \* CardText \* FirstCap} - sentence case

--
Cheers
macropod
[Microsoft MVP - Word]

Thanks a ton, for the formula...
but I'm a new word user....

would you please tell me, how do i go about using this in word..

supposing the text is:

The customer Mr A has paid an amount of USD 100 (USD One Hundred Only) today.

how do i get the One Hundred there???

after 100 i just type QUOTE \*CartText "1234"


????

Sorry...
:

Hi,

The QUOTE field with the \*CardText switch does this. For example, to
convert the number 1234 to words, insert a field, select QUOTE, and enter the
following code:
QUOTE \*CartText "1234"
--
Hope this helps,
Pesach Shelnitz


:

Is there any formula that i can use in a word document that would
automatically convert a number to its corresponding value in "words" ??

 

[Greg Maxey]

See:
http://gregmaxey.mvps.org/Spell_Out_Currency.htm

It doesn't tell you why, but offers a work around.

this formula does not work for numbers greater than 999,999
why is that?

ok sorry - one more doubt....

if i have a decimal number, how can i get the numbers after the
decimal also to get converted into text?

instead of cardtext, i tried dollar text and it read the number as
45/100 instead of and forty five

Hi Fuzzy,

Press Ctrl-F9 to create a pair of field braces (ie '{}')
Between the field braces, type '=1234 \* CardText' so that you end
up with {=1234 \* CardText }
Select the field and press F9.

The output will be in lower case. You can change the case by adding
another switch, eg: {=1234 \* CardText \* Upper} - upper case
{=1234 \* CardText \* Caps} - title case
{=1234 \* CardText \* FirstCap} - sentence case

--
Cheers
macropod
[Microsoft MVP - Word]


Thanks a ton, for the formula...
but I'm a new word user....

would you please tell me, how do i go about using this in word..

supposing the text is:

The customer Mr A has paid an amount of USD 100 (USD One Hundred
Only) today.

how do i get the One Hundred there???

after 100 i just type QUOTE \*CartText "1234"


????

Sorry...
:

Hi,

The QUOTE field with the \*CardText switch does this. For
example, to convert the number 1234 to words, insert a field,
select QUOTE, and enter the following code:
QUOTE \*CartText "1234"
--
Hope this helps,
Pesach Shelnitz


:

Is there any formula that i can use in a word document that would
automatically convert a number to its corresponding value in
"words" ??

 

[Fuzzy]

Yippieeee!! It worked!!!!
God Bless!!!!

See:
http://gregmaxey.mvps.org/Spell_Out_Currency.htm

It doesn't tell you why, but offers a work around.

this formula does not work for numbers greater than 999,999
why is that?

ok sorry - one more doubt....

if i have a decimal number, how can i get the numbers after the
decimal also to get converted into text?

instead of cardtext, i tried dollar text and it read the number as
45/100 instead of and forty five

:

Hi Fuzzy,

Press Ctrl-F9 to create a pair of field braces (ie '{}')
Between the field braces, type '=1234 \* CardText' so that you end
up with {=1234 \* CardText }
Select the field and press F9.

The output will be in lower case. You can change the case by adding
another switch, eg: {=1234 \* CardText \* Upper} - upper case
{=1234 \* CardText \* Caps} - title case
{=1234 \* CardText \* FirstCap} - sentence case

--
Cheers
macropod
[Microsoft MVP - Word]


Thanks a ton, for the formula...
but I'm a new word user....

would you please tell me, how do i go about using this in word..

supposing the text is:

The customer Mr A has paid an amount of USD 100 (USD One Hundred
Only) today.

how do i get the One Hundred there???

after 100 i just type QUOTE \*CartText "1234"


????

Sorry...
:

Hi,

The QUOTE field with the \*CardText switch does this. For
example, to convert the number 1234 to words, insert a field,
select QUOTE, and enter the following code:
QUOTE \*CartText "1234"
--
Hope this helps,
Pesach Shelnitz


:

Is there any formula that i can use in a word document that would
automatically convert a number to its corresponding value in
"words" ??

 

[Graham Mayor]

See http://www.gmayor.com/formatting_word_fields.htm for workarounds

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


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

this formula does not work for numbers greater than 999,999
why is that?

ok sorry - one more doubt....

if i have a decimal number, how can i get the numbers after the
decimal also to get converted into text?

instead of cardtext, i tried dollar text and it read the number as
45/100 instead of and forty five

Hi Fuzzy,

Press Ctrl-F9 to create a pair of field braces (ie '{}')
Between the field braces, type '=1234 \* CardText' so that you end
up with {=1234 \* CardText }
Select the field and press F9.

The output will be in lower case. You can change the case by adding
another switch, eg: {=1234 \* CardText \* Upper} - upper case
{=1234 \* CardText \* Caps} - title case
{=1234 \* CardText \* FirstCap} - sentence case

--
Cheers
macropod
[Microsoft MVP - Word]


Thanks a ton, for the formula...
but I'm a new word user....

would you please tell me, how do i go about using this in word..

supposing the text is:

The customer Mr A has paid an amount of USD 100 (USD One Hundred
Only) today.

how do i get the One Hundred there???

after 100 i just type QUOTE \*CartText "1234"


????

Sorry...
:

Hi,

The QUOTE field with the \*CardText switch does this. For
example, to convert the number 1234 to words, insert a field,
select QUOTE, and enter the following code:
QUOTE \*CartText "1234"
--
Hope this helps,
Pesach Shelnitz


:

Is there any formula that i can use in a word document that would
automatically convert a number to its corresponding value in
"words" ??

 

[Greg Maxey]

Johnny come late, the "Yippieeee!!" has already executed ;-)

See http://www.gmayor.com/formatting_word_fields.htm for workarounds

this formula does not work for numbers greater than 999,999
why is that?

ok sorry - one more doubt....

if i have a decimal number, how can i get the numbers after the
decimal also to get converted into text?

instead of cardtext, i tried dollar text and it read the number as
45/100 instead of and forty five

:

Hi Fuzzy,

Press Ctrl-F9 to create a pair of field braces (ie '{}')
Between the field braces, type '=1234 \* CardText' so that you end
up with {=1234 \* CardText }
Select the field and press F9.

The output will be in lower case. You can change the case by adding
another switch, eg: {=1234 \* CardText \* Upper} - upper case
{=1234 \* CardText \* Caps} - title case
{=1234 \* CardText \* FirstCap} - sentence case

--
Cheers
macropod
[Microsoft MVP - Word]


Thanks a ton, for the formula...
but I'm a new word user....

would you please tell me, how do i go about using this in word..

supposing the text is:

The customer Mr A has paid an amount of USD 100 (USD One Hundred
Only) today.

how do i get the One Hundred there???

after 100 i just type QUOTE \*CartText "1234"


????

Sorry...
:

Hi,

The QUOTE field with the \*CardText switch does this. For
example, to convert the number 1234 to words, insert a field,
select QUOTE, and enter the following code:
QUOTE \*CartText "1234"
--
Hope this helps,
Pesach Shelnitz


:

Is there any formula that i can use in a word document that
would automatically convert a number to its corresponding value
in "words" ??