Quote:
Originally Posted by macropod
You could use a macro like:
Code:
Sub NumberStringToNumeric()
...
End Sub
Note: the code assumes your number strings don't include the 'and' that is common in UK English, for example (e.g. one hundred and one). It's also not really designed for handling currencies or decimals, though it should handle the numeric aspects of those OK too. |
Thank you for the effort and time! WE APPRECIATE THAT A LOT
can you please write me a macro which does the opposite as well
i.e:
742111.37
676736.06
=
SEVEN HUNDRED FORTY TWO THOUSAND ONE HUNDRED ELEVEN AND THIRTY SEVEN CENTS
SIX HUNDRED SEVENTY SIX THOUSAND SEVEN HUNDRED THIRTY SIX AND POINT SIX CENTS
NOTE: " AND POINT SIX CENTS means .06"