display number in words in excel 2003
 

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

display number in words in excel 2003
 

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

On Nov 21, 2:35 pm, Montu wrote:
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

display number in words in excel 2003
 

NBTEXT is not a native Excel function. Are you trying to use Laurent
Longre's MoreFunc Add-In? If you want to include a currency name, don't you
need to include it in the syntax? Have you looked at the syntax definition
at http://xcell05.free.fr/morefunc/english/nbtexte.htm ?

For alternative solutions, try
http://support.microsoft.com/default...b;en-us;213360 or
http://support.microsoft.com/?scid=kb;en-us;259663
--
David Biddulph

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