Excel formula

[Closed]
Report
-
Posts
12
Registration date
Tuesday August 26, 2008
Status
Member
Last seen
February 24, 2009
-
Hello,

i want to know a formula from which i can get the answer in text.

For example if i right an amount in the cell A1 (100/-) i want the answer in cell B1 in words (One hundred only).

thanks

Amico

1 reply

Posts
12
Registration date
Tuesday August 26, 2008
Status
Member
Last seen
February 24, 2009
2
hi,
try this link to see if it can help you:
spreadsheets.about.com/od/excelformulas/ss/formula_begin.htm