![]() |
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. |
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. |
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. |
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. |
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