Have a look at these replies from earlier today:-

http://www.microsoft.com/office/comm...a-0f462946d8f1

Mike

"tc" wrote:

Is there a function to convert a numeric value to text and if notm,
how is it achieved through a macro?