I have found a script on the net that is provided by Microsoft to convert numerals to currency in Excel 2013.
I want it to convert any numerals up to 10,000 including any decimal fractions into words.
I have been able without any previous knowledge in visual basic to do part of what I want (I know it has not been cleanly done).
I would like you to edit this file or create from scratch one that will do as I want in the example below.
It is to be used in Excel 2013 as a formula?
1 = One
10 = Ten
11 = Eleven
100 = One Hundred
101 = One Hundred and One
110 = One Hundred and Ten
1,000 = One Thousand
1,001 = One Thousand and One
1,110 = One Thousand One Hundred and Ten
1,101 = One Thousand One Hundred and One
10.10 = Ten point Ten
10.1 = Ten point One
10.01 = Ten point Zero One
1,101.01 = One Thousand One Hundred and One point Zero One