Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
Method 3: Using the wrong button figures show that if those cells as text in the upper left corner there is an error indicator, please follow these steps. note that this method assumes that the background in Excel error-checking feature is turned on. If you have not open the error-checking feature, you must open it in order to use this method. 1. In the "Tools" menu, click "Options." 2. Click "Error Checking" tab. 3. click to select "Enable background error checking" checkbox. 4. Click to select "text in the form of digital storage" check box. 5. Click to select you want to open the other rules. 6. Click "OK." 7. click error indicator contains the cell. 8. Click the cell next to the wrong button, and then click "convert to digital." Method 4: Use "Paste Special" command to use Paste Special command, follow these steps: 1. in any empty cell, type the value 1. 2. Choose your type 1 in which the cell, and then click the "Edit" menu "Copy." 3. Select the value to convert the number of cells. 4. In the "Edit" menu, click "Paste." 5. In the "Actions", click "take." in the "Paste", click the "value", and then click "OK." 6. delete your blank cell, type the value 1. attention to certain billing procedures will show a negative (-) and on the right side of the value. To convert a string to the value of the text, you must return all the characters in a string of text (the most right, except the negative character), then the result multiplied by -1. For example, if cell A2 in a value of 156 -, then the text of the following formula can be converted to the value of -156: = LEFT (A2, LEN (A2) -1) *- 1 |
