PDA

View Full Version : converting numbers to letters in word



sz1979
01-26-2011, 03:17 AM
Dear members ,
How to convert numbers including three digits to letters in word
Thanks

macropod
01-26-2011, 03:22 AM
Hi sz,

1. Select the number and press Ctrl-F9 to enclose it in a pair of field braces (eg '{123}')
2. Insert '=' before the number and ' \* Cardtext' after it (eg '{=123 \* Cardtext}')
3. Press F9 to update.

sz1979
01-26-2011, 04:53 AM
Dearr macropod ,
Many thanks for your reply It's working Ok , But digits not showing ,
you've any solution for that ???
thanks

macropod
01-26-2011, 01:18 PM
Hi sz,

If you want the digits to show, you'll have to either bookmark them and point the field to the bookmark or use a table and point the filed to the cell containing them.

For example, if you bookmark the numbers with 'BkMk', you can code the field as '{=BkMk \* Cardtext}'
Similarly, if you put the numbers in the first cell of a two cell table, and the field in the second cell, you can code the field as '{=A1 \* Cardtext}'

fumei
01-26-2011, 01:51 PM
I am trying to make this work.

123.44

I am not sure what the OP wants to turn out as.

one hundred twenty three . fourty four ????

Although using both methods, I can not even get that.

123.44 is cell_A, and { =A1 \* Cardtext } shows as one hundred twenty three. No decimals.

Although, I am also not sure what "But digits not showing" actually means.

macropod
01-26-2011, 02:37 PM
Hi Gerry,

For the 123.44 you could use the Dollartext switch: '{=123.44 \* Dollartext}', but that would return 'one hundred twenty-three and 44/100'.

Here's a field code to spell out the lot as dollars and cents:

{QUOTE {ASK Val "What is the amount?"}"{=INT(Val) \* CardText} dollar{=INT(Val)-1 \# "s;s;"}{IF{=MOD(Val,1) \# 0.00}> 0 " and {=MOD(Val,1)*100 \# 0 \* CardText} cent{=INT(MOD(Val,1)*100-1) \# "s;s;"}"}"}

There's an even fancier one to spell it out in anglicized form:p

macropod
01-26-2011, 04:34 PM
For a macro to convert the field code text in my previous post into a working Word field, goto:
http://www.gmayor.com/export_field.htm#TextToField