<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o> Are there any formulas for converting Amount in number to Amount in text inenglish language?
<o> </o> i.e. - 253 to Two Hundred Fifty Three
Don't know about 2007 but prior to that release there is no native formula to do it. That said there are a number of custom built User Defined Functions (udf) out there that do this including this one by M$ themselves.