Forum Discussion

Copper Contributor

Feb 19, 2020

Error using the EnglishNumber formula

I have been using the english number formula for a couple of years now and all of a sudden I am getting an inexplicable error. I am using code from this website: https://www.techonthenet.com/excel/...

Formulas and Functions

Macros and VBA

ExcelExciting

MVP

Feb 20, 2020

Hi slider7420

Firstly make sure your macro is enable, i could be reason your macro is disabled the code is not working.

Have you tried using the spellnumber which is the same, maybe you can try this code.

https://support.office.com/en-us/article/convert-numbers-into-words-a0d166fb-e1ea-4090-95c8-69442cd55d98

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert | www.ExcelExciting.com

slider7420

Copper Contributor

Feb 20, 2020

ExcelExciting I have tried SpellNumber with the same result. Macros are definitely enabled as I have been using this for several years before this issue started. Also I should mention that it works in other files I have been using for the same amount of time with literally the same code, however if I make any changes to those files - even if I undo those changes - English Number seems to stop working. If I create a new file, copy the code from a working file - the new file does not work. I thought maybe the issue was specific to my PC but trying elsewhere has the same result. I am at a loss.