how to express a numerical in number words eg. 100 = one hundred

P

Paul Lynch

i want to automate a checking system in excel - i need a way of expressing a
numerical in to number words automatically - for example

cell a1 is £11,503.63
want function so that cell a2 reads "Eleven thousand five hundred and three
pounds and sixty three pence"

Anyone know how to help?

Thanks

Paul
 

Ask a Question

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.

Ask a Question

Similar Threads

HOW DO I CONVERT A NUMERIC IN WORDS? EG. 100 (ONE HUNDRED) 1
convert number value to words of numerical value 4
Turn numbers into words to automate check-writing 3
Convert Number to words 1
Converting currency to text and spliting to two lines 14
How do I display a number in writing (letters) 1
how to convert 100 in figuers to one hundred in spelling 2
Numaric to Inword in excel by VB 1

Top