Microsoft KB Archive/35714: Difference between revisions
(importing KB archive) |
m (Text replacement - "&" to "&") |
||
Line 31: | Line 31: | ||
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: | 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: | ||
<pre> =FORMULA("="""& | <pre> =FORMULA("="""&INPUT("Enter Number",2)&"""",ACTIVE.CELL()) | ||
</pre> | </pre> | ||
== REFERENCES == | == REFERENCES == |
Latest revision as of 14:13, 21 July 2020
Entering Numbers as Text Through an Input BoxLast reviewed: November 4, 1994 |
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:
SUMMARYWhen using a type 2 (text) input box in an Excel macro, numeric text data entered as text will evaluate to a value. MORE INFORMATIONTo 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("="""&INPUT("Enter Number",2)&"""",ACTIVE.CELL()) REFERENCES"Microsoft Excel Function Reference," version 3.0, pages 131, 132 |
KBCategory: kbusage |
Last reviewed: November 4, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.