Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Can anyone help?
I want to be able to a macro / function that reads a cell and converts the number to words, e.g. 111 = One Hundred and Eleven. 57 = Fifty seven Sounds straight forward but I'm coming unstuck. Thanks |
#2
![]() |
|||
|
|||
![]() Graeme Wrote: Can anyone help? I want to be able to a macro / function that reads a cell and converts the number to words, e.g. 111 = One Hundred and Eleven. 57 = Fifty seven Sounds straight forward but I'm coming unstuck. Thanks Hi Graeme Have a look at this thread http://www.excelforum.com/showthread.php?t=478470 -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=482234 |
#3
![]() |
|||
|
|||
![]()
Graeme, have a look here,
http://www.xldynamic.com/source/xld.xlFAQ0004.html -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Graeme" wrote in message ... Can anyone help? I want to be able to a macro / function that reads a cell and converts the number to words, e.g. 111 = One Hundred and Eleven. 57 = Fifty seven Sounds straight forward but I'm coming unstuck. Thanks |
#4
![]() |
|||
|
|||
![]()
Hi Graeme
See: http://support.microsoft.com/default...EN-US;Q213360& or http://support.microsoft.com/default...N-US;q140704&; -- Gary's Student "Graeme" wrote: Can anyone help? I want to be able to a macro / function that reads a cell and converts the number to words, e.g. 111 = One Hundred and Eleven. 57 = Fifty seven Sounds straight forward but I'm coming unstuck. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
converting numbers to text | New Users to Excel | |||
about converting numbers to text. | Excel Discussion (Misc queries) | |||
Cells formated as numbers are calculating like text | Excel Discussion (Misc queries) | |||
how to format numbers stored as text or vice versa to use vlookup | Excel Worksheet Functions | |||
converting numbers to text and prefill text field with 0's | Excel Discussion (Misc queries) |