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.
|