Hi,
I have Spellnumber activated in Excel 2002 on Windows XP and working fine using the popular code provided by Microsoft.
I have searched the forum and haven't found exactly what I was looking for so apologies if it has been posted somewhere before.
I need Spellnumber to convert to non-currency text in capitals and to 4 decimals places.
I also need the highest number it can convert to at least 499,999.9999.
As an example it should read as follows:
125,765.8067 = ONE HUNDRED AND TWENTY FIVE THOUSAND SEVEN HUNDRED AND SIXTY FIVE POINT EIGHT ZERO SIX SEVEN
If someone could provide some code for this then I would be most grateful. Having it in capitals would be a bonus put not essential.
Many Thanks
I have Spellnumber activated in Excel 2002 on Windows XP and working fine using the popular code provided by Microsoft.
I have searched the forum and haven't found exactly what I was looking for so apologies if it has been posted somewhere before.
I need Spellnumber to convert to non-currency text in capitals and to 4 decimals places.
I also need the highest number it can convert to at least 499,999.9999.
As an example it should read as follows:
125,765.8067 = ONE HUNDRED AND TWENTY FIVE THOUSAND SEVEN HUNDRED AND SIXTY FIVE POINT EIGHT ZERO SIX SEVEN
If someone could provide some code for this then I would be most grateful. Having it in capitals would be a bonus put not essential.
Many Thanks
