ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Record numbers and get the output printed in words (https://www.excelbanter.com/excel-programming/408621-record-numbers-get-output-printed-words.html)

RiverGully

Record numbers and get the output printed in words
 
I would like to enter numbers for a cheque payment and have excel convert the
numbers into words. For example: $1,250 entered should return One Thousand
Two Hundred and Fifty dollars.

Thank you.

Mike H

Record numbers and get the output printed in words
 
Hi,

Several sites provide code to do this, here's one that's as good as any.

http://www.ozgrid.com/VBA/ValueToWords.htm

Mike

"RiverGully" wrote:

I would like to enter numbers for a cheque payment and have excel convert the
numbers into words. For example: $1,250 entered should return One Thousand
Two Hundred and Fifty dollars.

Thank you.


Gary''s Student

Record numbers and get the output printed in words
 
see:

http://support.microsoft.com/default...EN-US;Q213360&
--
Gary''s Student - gsnu200776


"RiverGully" wrote:

I would like to enter numbers for a cheque payment and have excel convert the
numbers into words. For example: $1,250 entered should return One Thousand
Two Hundred and Fifty dollars.

Thank you.


ryguy7272

Record numbers and get the output printed in words
 
....and one more for good measu
http://www.xldynamic.com/source/xld.xlFAQ0004.html


Regards,
Ryan---

--
RyGuy


"Gary''s Student" wrote:

see:

http://support.microsoft.com/default...EN-US;Q213360&
--
Gary''s Student - gsnu200776


"RiverGully" wrote:

I would like to enter numbers for a cheque payment and have excel convert the
numbers into words. For example: $1,250 entered should return One Thousand
Two Hundred and Fifty dollars.

Thank you.


RiverGully

Record numbers and get the output printed in words
 
Thank you. The solution worked - I liked the Microsoft site referral.

Regards... Clive

"RiverGully" wrote:

I would like to enter numbers for a cheque payment and have excel convert the
numbers into words. For example: $1,250 entered should return One Thousand
Two Hundred and Fifty dollars.

Thank you.



All times are GMT +1. The time now is 10:36 AM.

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