View Single Post
 
Old 01-28-2019, 07:55 PM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2007
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 553
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default 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.
Reply With Quote