PC Review


Reply
Thread Tools Rate Thread

Convert Numbers to Words for UK format

 
 
New Member
Join Date: Jun 2011
Posts: 1
 
      14th Jun 2011
Hi

I have searched high and low and have not been successful in finding a solution to my problem.

My requirement is: I want to convert numbers into words for cheque printing in the United Kingdom.

Example: 555.55
UK Format: Five Hundred and Fifty Five Pounds and Fifty Five Pence only

None of the solutions that I have found on the internet put the word "and" above highlighted in red

Problems:

1. NumToWords VBA - Five Hundred Fifty Five Pounds and Fifty Five Pence only (no "and").

2. SpellNumber - Five Hundred Fifty Five Pounds and Fifty Five Pence only

Can someone please help. It seems so small but I have been looking for a solution for hours.

Appreciate your help
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
numbers convert into words numbers into words Microsoft Excel Misc 2 27th Sep 2008 12:33 PM
numbers convert into words numbers into words Microsoft Excel Misc 1 27th Sep 2008 12:27 PM
Convert numbers to words LCalaway Microsoft Access Queries 1 7th Aug 2005 12:01 AM
convert numbers to words =?Utf-8?B?cHJhZ3M=?= Microsoft Excel Worksheet Functions 2 4th Jul 2005 09:52 PM
how to convert numbers to words vinay Microsoft Excel Worksheet Functions 3 19th Apr 2004 03:36 PM


Features
 

Advertising
 

Newsgroups
 


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