Converting words (spelled out numbers) into actual numbers

Check out JL0001 at link below. Please note I am not the author of the code and am in no way trying to take credit for it.

http://www.contextures.com/excelfileslatham.html

Hello Me_in_va,

I don't think what you are looking for is possible. Please consider the example below;

Three Million Eighty Hundred Thousand and Forty Four Dollars: First the system will have to create a number of Three Million, 3,000,000, and now it becomes stuck with the commas which could be interpreted as text. Now how would the system know where to enter the Eighty Hundred Thousand - 800,000- again with the damn comma, and then to top it all, the; "and" Forty Four Dollars, since the "and" which could appear anywhere in a large number, whilst being read as "Text", will throw another spanner in the "works".?

Regards.

@ walruseggman,

Nice link indeed!

It is worthy though to note the absence of the normally used "and" with large numbers, hence the motivation to my reply.

Regards.

Perhaps remove every comma and every " and " - spaces necessary to ensure we ignore "and" in "thousand"

@kev,

Good idea, which would require a separate Macro for "Cleaning" up, but it could lead to confusion reading the total correctly

Regards.

Also need to get rid of hyphens
Require single space between every word and then testing groups of of words
If we go as big as (US) billion (UK billion was a million million when I went to school - but our billion was deflated and now matches the inferior US billion ),
Would need to remove these strings in reverse order:
"zero" or "nil" or "nothing" or "zilch" to "nine"
"ten" to "ninety nine"
"one hundred" to "nine hundred"
"one thousand" to "nine hundred ninety nine thousand"
"one million" to "nine hundred ninety nine thousand million"

replacing them via a lookup with numbers

finally adding the whole thing up

I think we should just ask the employee to input own data again - and supervise data entry this time!

Just a thought - is the employee good at spelling?
Ignoring typos, some good pairings:
forty/fourty
eight/ate
two/too
for/four
etc