spell out amount?

H

Helen

Hi there,

I'm working on a spreadsheet on which I have to spell out an amount. You
know, like they do on checks; One Thousand Three Hundred 00/100...

Is there a way to do this in Excel? Maybe an add-in or a third party
software?

Thanks!

Helen
 
R

Ron Rosenfeld

Hi there,

I'm working on a spreadsheet on which I have to spell out an amount. You
know, like they do on checks; One Thousand Three Hundred 00/100...

Is there a way to do this in Excel? Maybe an add-in or a third party
software?

Thanks!

Helen
Click to expand...

Download and install Longre's morefunc.xll free add-in from
http://xcell05.free.fr/

Then use the formula:

=NBTEXT(A1,,2)&TEXT(MOD(A1,1)," 00/100")


--ron
 
Top