Microsoft KB Archive/35714

-

{| 2.x 3.00 4.00 4.00a 5.00 | 2.20 2.21 3.00 WINDOWS                 | OS/2 kbusage The information in this article applies to:
 * width="100%"|


 * Microsoft Excel for Windows, version 2.x, 3.0, 4.0, 4.0a, 5.0
 * Microsoft Excel for OS/2 versions 2.2, 2.21, 3.0

SUMMARY
When using a type 2 (text) input box in an Excel macro, numeric text data entered as text will evaluate to a value.

MORE INFORMATION
To enter numbers as text entries, you must add an equal sign and quotes to the string before placing on a sheet. For example, the following formula will place a number entered in the input box in the active cell as text:

=FORMULA(&quot;=&quot;&quot;&quot;&INPUT(&quot;Enter Number&quot;,2)&&quot;&quot;&quot;&quot;,ACTIVE.CELL)