Converting Microsoft Excel Values to Text in an Excel Macro (64681)
The information in this article applies to:
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q64681 SUMMARY
The following macro command will convert a numeric value in the active cell
to a text string:
=FORMULA("="&CHAR(34)&ACTIVE.CELL()&CHAR(34))
For example, when you run this command on a cell that contains the
following entry:
the entry is converted to the following:
Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
---|
Keywords: | kbcode kbhowto kbProgramming KB64681 |
---|
|