Excel 97 Formula

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

Guest

Help! I use Excel 97 to print weekly paychecks. I have looked for a formula to convert my numeric dollar amount to the written/alph dollar amount as it should appear on a check but have not had any success. I'm not sure if I am not looking for the correct "name" or if it doesn't exist. Can anyone help me, please? Thanks!
 
Hi
there're some macros/procedures to convert numbers to text. e.g.
MS Knowledge Base:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;213360
http://support.microsoft.com/default.aspx?scid=KB;EN-US;140704&

Free Addin MOREFUNC-DLL which includes a UDF for this task (for various
languages):
http://longre.free.fr/english/

or have a look at
http://www.bygsoftware.com/examples/zipfiles/num2wrds.zip
It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains two methods


--
Regards
Frank Kabel
Frankfurt, Germany

Angela said:
Help! I use Excel 97 to print weekly paychecks. I have looked for a
Click to expand...
formula to convert my numeric dollar amount to the written/alph dollar
amount as it should appear on a check but have not had any success.
I'm not sure if I am not looking for the correct "name" or if it
doesn't exist. Can anyone help me, please? Thanks!
 
Microsoft provides some code here:

http://support.microsoft.com/default.aspx?scid=kb;en-
us;140704

HTH
Jason
Atlanta, GA
-----Original Message-----
Help! I use Excel 97 to print weekly paychecks. I have
Click to expand...
looked for a formula to convert my numeric dollar amount
to the written/alph dollar amount as it should appear on a
check but have not had any success. I'm not sure if I am
not looking for the correct "name" or if it doesn't
exist. Can anyone help me, please? Thanks!
 
Back
Top