format as text

來源: 2005-08-19 10:25:56 [舊帖] [給我悄悄話] 本文已被閱讀:

Format numbers as text
Format cells as text
Select the cells you want to format.
On the Format menu, click Cells, and then click the Number tab.
In the Category list, click Text, and then click OK.
Enter the numbers in the formatted cells.
Format existing numbers as text
If you've already entered the numbers, you can change the numbers to text data.

Select the cells that contain the numbers you want to format as text.
On the Format menu, click Cells, and then click the Number tab.
In the Category list, click Text, and then click OK.