Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching numbers in Worksheet? | Excel Worksheet Functions | |||
conditional formatting | Excel Worksheet Functions | |||
How to generate sets of random numbers without having duplicates | Excel Worksheet Functions | |||
Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) |