how to get word amounts from numbers in cels
 

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

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...;EN-US;Q213360

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

Regards

Trevor


"DONPITO" wrote in message
...
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

DONPITO Wrote:
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


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=401999