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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
