| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I delete the words Page 1 printed across my spreadsheet? | Excel Discussion (Misc queries) | |||
| Words on screen are larger when printed. | Excel Discussion (Misc queries) | |||
| PrintOut and PrintPreview show only first record when printed using ADO and VBA | Excel Programming | |||
| Where can I find a printed list of VBA code words | Excel Discussion (Misc queries) | |||
| How do I hide words on a printed document, but see on screen? | Excel Discussion (Misc queries) | |||
Hybrid Mode
