ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I convert numbers to written out text ex. 25 = Twenty Five (https://www.excelbanter.com/excel-discussion-misc-queries/203650-how-do-i-convert-numbers-written-out-text-ex-25-%3D-twenty-five.html)

grumpydope

How do I convert numbers to written out text ex. 25 = Twenty Five
 
I use Excel 2007 to track my finances. I would like it to write out checks. I
need to be able to convert a number such as 25.40 to Twenty Five Dollars and
Forty Cents.
Any help would be greatly appreciated.

bpeltzer

How do I convert numbers to written out text ex. 25 = Twenty Five
 
You can check Microsoft.com for 'spellnumber'; that got me to
http://support.microsoft.com/kb/213360

"grumpydope" wrote:

I use Excel 2007 to track my finances. I would like it to write out checks. I
need to be able to convert a number such as 25.40 to Twenty Five Dollars and
Forty Cents.
Any help would be greatly appreciated.


Gord Dibben

How do I convert numbers to written out text ex. 25 = Twenty Five
 
http://www.xldynamic.com/source/xld.xlFAQ0004.html


Gord Dibben MS Excel MVP

On Tue, 23 Sep 2008 17:38:00 -0700, grumpydope
wrote:

I use Excel 2007 to track my finances. I would like it to write out checks. I
need to be able to convert a number such as 25.40 to Twenty Five Dollars and
Forty Cents.
Any help would be greatly appreciated.




All times are GMT +1. The time now is 12:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com