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

http://support.microsoft.com/default...B;EN-US;213360

--
Kind regards,

Niek Otten

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

Check the MS site for 'spellnumber':
http://support.microsoft.com/default...b;en-us;213360
--Bruce


"Helen" wrote:

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

On Mon, 14 Nov 2005 08:29:46 -0800, "Helen" wrote:

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


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

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


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