Tuesday, September 28, 2010

Set number format to solve such problems arise when



1. Figures do not show up or not to conduct operations in digital form

If the number of left-aligned in the cell, and modified the default alignment (the default mode for the conventional), then the figures are entered as text or format. To change it to numerical form, need to proceed as follows.

Select is set to "conventional" digital format cell. If you can not determine the format of the cell, run the "Format" menu in the "cell" command, and then in the pop-up dialog box, click the "digital" tab. In the "Category" box, click the "General", then click "OK" button.

In the selected cell, type "1", then press the Enter key. Click the cell, and then click the "Format" toolbar "Copy" button. Selected with the "text" as the copy number of target cells in the cell, the implementation of the "Edit" menu "Paste Special" in the pop-up dialog box select the "x", then click "OK" button.

2. How to display leading zeros in numbers with zero or after

Users can use a custom number format to retain the leading figures in the input with zero or after the zero, first select the cell you want to format. Click the "Format" menu "cell" command, and then click the "digital" tab. Select "Category" list "Custom" option. In the "Type" box, edit the number format codes to create the required format.

Edit internal format does not remove the format.

3. The number of set text format

Select the cells you want to format, click the "Format" menu in the "cell" command, and then click the "digital" tab. In the "Category" list, click the "text", then click "OK" button. Thus, the format has been set up to enter the cell number will be processed as text.

4. Decimal point appear in the input of all data

Implementation of the "Tools" menu in the "Options" command, click the "Edit" tab, then clear the "Automatically set the decimal point" check box. Figures have been entered from the removal of the decimal point, can the number 10 raised to a power multiplied by a number. To remove the decimal point according to a different location, in a blank cell, enter, such as 10,100, or 1,000 of such figures. For example, if a certain number contains two decimal places and need the whole number, at a blank cell, enter 100, then copy the cell, then select the cell containing the decimal Di (Xuanding all cells must be yes Xiang Lin's ), click the "Edit" menu "Paste Special" command, and then click the "take."

5. Enter the text or other data in the cells did not show

There are two solutions:

鈶?reset the number format

The format of the cell may be set to hide data. To remove the designation may affect the value displayed in digital format, can first select the cell, and then click the "Format" menu in the "cell" command, and then click the "digital" tab, in the "Category" list, single Click the "General."

鈶?check the background and text colors

If the cell text color and background color are the same, the cell will not see anything, then you can change the background color or change the text color.







相关链接:



jsp, servlet talk about CHINESE issues



brief Browsers



Gartner: Q4 PC shipments in Asia-Pacific region surged 32.6 percent year on year



My favorite Food And Drink



ArcGIS standard coordinate conversion in the end how?



All roads lead to full HIGH-DEFINITION video equipment HD Thunder



Create a simple window



Lists Graphic



Components And Libraries reviews



Effects Authorware word album (2)



11n Vs. 150M And 300M Internal Battle Cost The King



AVI TO MOV



MKV to Zune



Free Visual Style



FLV to iPod



No comments:

Post a Comment