Converting Date to words / Integer division problem

[Joeindio]

Hi people,

I have a workbook which has some dates that must be spelled out in text (in Portuguese, but the problem's similar in English).

Now, I worked up a solution with formulas, but would like to use a UDF so it's cleaner. So you see clearly what I want to do, the formula should have:

Input: a cell with a date on it, e.g. 26/10/2005
Output: the input date spelled out, e.g. "October Twenty-Sixth Two Thousand and Five"

Any clues on how I could implement something like this?

Thank you all for any help

(i can post the formulas example if you're interested, just let me know)

Joe@CV

 

[Greg Truby]

Maybe some of the links that Juan Pablo offered here would give you a couple of ideas...www.mrexcel.com/board2/viewtopic.php?t=76437

And you might search here. I know the topic of converting numbers to text has come up more than once.