numbers...
 

Is there a way that one could type out numbers and have their numerical
equivalent appear in a cell?

Example: typing "one million" would make 1000000 appear in the cell.
--
Brevity is the soul of wit.

numbers...
 

Not really. Everything can be programmed, but this would be very hard and
not outstandingly useful.

HTH. Best wishes Harald

"Dave F" skrev i melding
...
Is there a way that one could type out numbers and have their numerical
equivalent appear in a cell?

Example: typing "one million" would make 1000000 appear in the cell.
--
Brevity is the soul of wit.

numbers...
 

My thoughts, exactly.

But if you were a course instructor it would make a good
problem that probably hasn't already been solved and posted
Simply the reverse of but still reading from left to right to solve,
hopefully with American wording where "and" means decimal
fraction as opposed the English where "and" could appear elsewhere
as well. Convert everything to the same case (lower case) within the
VBA function or macro so can be interpreted.
http://www.mvps.org/dmcritchie/excel...numberstowords
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Harald Staff" wrote in message ...
Not really. Everything can be programmed, but this would be very hard and
not outstandingly useful.

HTH. Best wishes Harald

"Dave F" skrev i melding
...
Is there a way that one could type out numbers and have their numerical
equivalent appear in a cell?

Example: typing "one million" would make 1000000 appear in the cell.
--
Brevity is the soul of wit.

numbers...
 

Yeah I don't think it would be useful either. Came up in a discussion.
--
Brevity is the soul of wit.


"David McRitchie" wrote:

My thoughts, exactly.

But if you were a course instructor it would make a good
problem that probably hasn't already been solved and posted
Simply the reverse of but still reading from left to right to solve,
hopefully with American wording where "and" means decimal
fraction as opposed the English where "and" could appear elsewhere
as well. Convert everything to the same case (lower case) within the
VBA function or macro so can be interpreted.
http://www.mvps.org/dmcritchie/excel...numberstowords
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Harald Staff" wrote in message ...
Not really. Everything can be programmed, but this would be very hard and
not outstandingly useful.

HTH. Best wishes Harald

"Dave F" skrev i melding
...
Is there a way that one could type out numbers and have their numerical
equivalent appear in a cell?

Example: typing "one million" would make 1000000 appear in the cell.
--
Brevity is the soul of wit.