Excel - number in words

pigface | 18:57 Thu 14th Feb 2008 | Technology

2 Answers

Does anyone know of a method of converting a number in Excel into words. For example, if I write �116.73 can I format the next cell to write "one hundred and sixteen pounds and seventy three pence" automatically, and enable it the change when I change the number?

Does anyone know how to insert a World Clock in an Excel Spreadsheet?

Linux (Kbuntu)

Answers

1 to 2 of 2

Best Answer

No best answer has yet been selected by pigface. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

kempie

You can write (copy/paste) your own function to achieve this by following the instructions provided here...

http://support.microsoft.com/kb/213360

but remember to change the references to Dollar, Dollars, Cent & Cents to Pound, Pounds, Penny & Pence.

ACtheTROLL

any use??

http://www.meadinkent.co.uk/xlnumberstext.htm

1 to 2 of 2

Do you know the answer?