I wonder if it is possible to convert words into numbers.
I have a column with amounts in words, say seven hundred and fifty. I have to convert this into 750 in another column.
There are over four thousands of them which I have to key the actual numbers in.
The formats are like this: four thousand nine hundred and twenty-five.
three hundred and twenty five, etc. The word 'and' always follow the hundred.
Is there a quick way to convert words into number formats please? No cents involved.
Thank you for help.
I have a column with amounts in words, say seven hundred and fifty. I have to convert this into 750 in another column.
There are over four thousands of them which I have to key the actual numbers in.
The formats are like this: four thousand nine hundred and twenty-five.
three hundred and twenty five, etc. The word 'and' always follow the hundred.
Is there a quick way to convert words into number formats please? No cents involved.
Thank you for help.