There are several bits of code about that will do this but one excellent
solution is to instal the Excel addin 'Morefunc' which is free and contains
many useful functions including one called =NBTEXT() which will convert a
number to text. The addin is very easy to install.