spell out amount?
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 |
spell out amount?
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 |
spell out amount?
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 |
spell out amount?
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 |
spell out amount?
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 |
All times are GMT +1. The time now is 02:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com