Is there a formula for converting Text to Numbers? I would like to change Text entered in the cells of A1 and B1 to Numbers in the cells C1 and D1, Text entered in A2 and B2 to Numbers in C2 and D2, etc. *while* I am typing them in, not *after* the colums A and B have been filled in completely.
For instance:
The desired output after typing in Text in the cells in colums A and would be as follows in the cells in colums C and D:
A B C D
<tbody>
</tbody>
Thank you very much for any assistance,
Bertha
For instance:
The desired output after typing in Text in the cells in colums A and would be as follows in the cells in colums C and D:
A B C D
fourteen | six | 14 | 6 |
five | three | 5 | 3 |
two | zero | 2 | 0 |
twenty-eight | sixty-three | 28 | 63 |
<tbody>
</tbody>
Thank you very much for any assistance,
Bertha