numbers...

D

Dave F

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.
 
H

Harald Staff

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

HTH. Best wishes Harald
 
D

David McRitchie

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/strings.htm#numberstowords
 
D

Dave F

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


David McRitchie said:
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/strings.htm#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 said:
Not really. Everything can be programmed, but this would be very hard and
not outstandingly useful.

HTH. Best wishes Harald
Click to expand...
Click to expand...
 
Top