display number in words in excel 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have got the answer from this forum, but problem is that, it's not display
paise. supose, if write 1943.50 it display "One thousand nine hundred
forty-three, fifty." inspite of "One thousand nine hundred forty three and or
& fifty paise only." The formula which I have used is =nbtext(Cell
address,2). Is there any another formula to display paise. help me
 
I don't know if I understand you correctly, but you could do:
=LEFT(A1,FIND(",",A1)-1) & " and " &
TRIM(RIGHT(A1,LEN(A1)-FIND(",",A1))) &
" paise only"

(you need to exchange all A1 references with your formula)
although i have no idea what you mean by "paise"

hth

Carlo
 
Back
Top