Microsoft KB Archive/46395

Excel: Converting Numbers to Text on a Worksheet without Macro PSS ID Number: Q46395 Article last modified on 02-26-1993 PSS database name: W_eXceL

2.x 3.00

WINDOWS

Summary:

In Excel 3.0, the TEXT function will convert numbers to text. The format must be included with this function. If general formatting is required, one of the two methods below must be used. For example, if you have numbers in cells A1 through A10 and you want to convert these numbers to text you may do the following:

More Information:

Method 1

 * 1) Type =&quot;“&A1&”&quot; in B1.
 * 2) Select B1:B10 with B1 as the active cell.
 * 3) From the Edit menu, choose Fill Down.
 * 4) From the Edit menu, choose Copy.
 * 5) Select A1.
 * 6) From the Edit menu, choose Paste Special.
 * 7) Select Values.
 * 8) Click OK.
 * 9) Delete the B column.

Method 2

 * 1) In cell B1, enter the string function RIGHT(A1,10) or LEFT(A1,10). This assumes that 10 is the longest number including the decimal (that is, 1234567.89).
 * 2) Follow Steps 2 - 9 above.

Reference(s):

“Microsoft Excel Function Reference,” version 3.0, pages 234-235

Additional reference words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0 3.00 converting numbers to text

Copyright Microsoft Corporation 1993.