A quick search in Microsoft's Knowledge base turned up -

How to convert a numeric value into English words in Excel
http://support.microsoft.com/default...b;en-us;213360
This article contains sample Microsoft Visual Basic for Applications
functions that you can use to convert a numeric value in a Microsoft Excel
worksheet cell into its equivalent in English words.

and

How To Convert Currency or Numbers into English Words
http://support.microsoft.com/default...b;en-us;259663
This article shows you how to create a sample, user-defined function named
ConvertCurrencyToEnglish() to convert a numeric value to an English word
representation. For example, the function returns the following words for the
number 1234.56:
One Thousand Two Hundred Thirty Four Dollars And Fifty Six Cents

HTH,
Gary Brown


"gmet" wrote:

I need to produce a template for completing preprinted checks(cheques). How
do I
convert the total figure into text eg. 1,234 - one two three four
Thanks