Wednesday, August 10, 2005

User Defined Function (UDF) Request


I found this request in a forum at DigDB.com
Dear Sir,

Could you please help me to find a solution for the following problem. I have been trying to find a solution for a long time and finaly I saw this website, I feel I am lucky.

I want convert or translate a mathematical figure in an excel shorksheet to english words. for example:

My bill total comes in cell A1, I want that total to be appear in words in next cell.

If Cell A1 = 100.55 ( This is my bill total )
Cell A2 = One Hundred & Five Five Only. ( This is my bill total in words )

I hope you have understand me and look forward to hearing from you soon.

Thank you


Have a go at solving it and post your responses either in the comments or by email to me.


Posted by: Jethro | 1:31 AM |