Hi,

You are going to need to show us all the possible text entries. Otherwise
there are an infinite number of possibiliities, for example

"Zero"
"None"
"Seven Trillion Eight Hundred and Fifty Nine Million Six Hundred and Thirty
Two Thousand One Hundred and Forty Nine and Twenty Three Cents"


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Tom" wrote:

How can I convert a text word (i.e. None) to a number (i.e 0)?