Microsoft KB Archive/46145

-

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


 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0
 * Microsoft Excel for OS/2, versions 2.x, 3.0
 * Microsoft Excel for the Macintosh, versions 2.x, 3.0, 4.0, 5.0

SUMMARY
Using the TEXT function within the FORMULA function in a macro always returns the number value to the worksheet. For example:

Macro_Name =FORMULA(TEXT(ACTIVE.CELL,&quot;####&quot;),ACTIVE.CELL) =RETURN The TEXT function does return the number as text to the FORMULA statement. However, through the transition from the macro to the worksheet, the TEXT number is placed on the worksheet as a number. For more information, query on the following words:

Convert Number TEXT Excel NOTE: The TEXT function does work properly when used on the worksheet alone.
 * }

-

Last reviewed: December 2, 1994

© 1998 Microsoft Corporation. All rights reserved. Terms of Use.