how to get word amounts from numbers in cels

[Guest]

I AM USING OFFICE 2003 EXEL, AND IN MY COLUMS WHEN I MAKE A
SUM , THE RESULT OVIOUSLY COMES IN NUMBERS, MY QUESTION IS HOW
CAN I OREDR EXEL TO WRITE, A NUMBER IN WORDS IN THE CEL BELOW TO IT

 

[Trevor Shuttleworth]

Try searching Google with Excel numbers in words as the search criteria ...
lots of advice and code.

Some examples:

http://www.meadinkent.co.uk/xlnumberstext.htm
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360

Please try not to use all capital letters ... it doesn't make it any easier
to read.

Regards

Trevor

 

[Paul Sheppard]

I AM USING OFFICE 2003 EXEL, AND IN MY COLUMS WHEN I MAKE A
SUM , THE RESULT OVIOUSLY COMES IN NUMBERS, MY QUESTION IS HOW
CAN I OREDR EXEL TO WRITE, A NUMBER IN WORDS IN THE CEL BELOW TO IT

Hi Donpito

Try this ----> http://www.meadinkent.co.uk/xlnumberstext.htm