|
|
#1
01-28-2019, 07:55 PM
|
||||
|
||||
Macro to read years into words
Hi, would somebody please provide the code that will automatically convert years in column A into words in column B, like:
cell A2 - 1914 In B2, the code should convert 1914 into "Nineteen Hundred Fourteen" Cell A3 - 2019 In B2, "Twenty Hundred Nineteen" This is used in issuing baptismal certificates that says,"in the year of our Lord Nineteen Hundred Fourteen" Thank you. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Use macro on form activate attached to read only file
|
smarti | Word VBA | 3 | 03-02-2017 09:06 AM |
|
Macro to read cell contents and compare data
|
jrfoley3 | Excel Programming | 7 | 07-09-2016 12:25 PM |
|
Macro will not read the value of cell with a formula in it!
|
grayson1231 | Excel Programming | 10 | 03-28-2015 03:47 PM |
| Email macro to read range for .To field | MattMurdock | Excel Programming | 2 | 08-07-2012 06:46 AM |
|
Macro to read word document
|
harishankar.selvaraju | Excel Programming | 1 | 06-14-2012 03:48 AM |
Windows 7 32bit 
Office 2007
Threaded Mode