Hi m_azim1,
An alternative to a macro is to use Word for this conversion. Word fields
accept \* CardText, which displays results as cardinal text. To see how this
works, go to Word.
Press Ctrl + F9 to insert a field. Between the braces, type
= 126 \* CardText \* Caps
Press Ctrl + Shift +F9 and you will see One Hundred Twenty-Six. (The *Caps
makes the first letter upper case).
You can copy/paste excel tabular data to word, and edit the field
referencing row and columns, such as
{ = SUM(A1:B2) \* CardText \* Caps } in your Word report.
I don't know of any function equivalent in Excel, but perhaps someone else
may.
Cheers,
Annie
"m_azim1" wrote:
Hi,
Pl. give refrence for converting a figure (eg. 102 ) into a text (
One hundred and two ) in excel for a accoutning work. Will macro will
be able to handle this !
Thanks
M. Azim
--
m_azim1
------------------------------------------------------------------------
m_azim1's Profile: http://www.excelforum.com/member.php...o&userid=33181
View this thread: http://www.excelforum.com/showthread...hreadid=529988