how do i show figures as words?
 

I'm sure I've seen a spreadsheet where a number was entered into a cell, and
there was another cell which must have contained a formula to show that
figure in words (eg. for writing a cheque), does anybody out there know how
to do this? It's probably really simple!!

Cheers
Carolyn

See http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
HTH

Bob Phillips

"Carolyn" wrote in message
...
I'm sure I've seen a spreadsheet where a number was entered into a cell,
and
there was another cell which must have contained a formula to show that
figure in words (eg. for writing a cheque), does anybody out there know
how
to do this? It's probably really simple!!

Cheers
Carolyn