THERE ARE POSITIVE AND NEGATIVE NUMBERS IN EXCEL, HOW TO ACHIEVE THAT ONLY POSITIVE NUMBERS ARE RETU

Possible causes and workarounds.

The column width is not enough to show what's included.

Increase Column Width Select the column, point to Columns on the Format menu, click Column Width, and then enter a number.

Shrink Font Fill Select the column, and then, on the Format menu, click Cells, click the Align tab, and then select the Shrink Font Fill check box.

Apply a different number formatting In some cases, you can change the formatting of the numbers in a cell to fit the width of the existing cell. For example, you can reduce the number of decimal places after the decimal point.

Both the date and time are negative.

If you use the 1900 date system, the date and time in Microsoft Excel must be positive.

If you are subtracting dates and times, you should make sure that the established formula is correct.

If the formula is correct, although the result is a negative value, the value can be displayed by formatting the cell to a non-date or time format. Click Cells on the Format menu, click the Numbers tab, and then select a format that is not a date or time.

Material Tools: Excel software.

Operation steps: 1. Open the excel software and randomly establish a set of positive numbers.

2. Then, enter "-1" in the spine of other blank cells adjacent to each other in this set of data.

3. Select "-1" and right-click and select the "Copy" option.

4. Select all the positive numbers created earlier**, right-click and select the "Paste Special" option.

5. Note that after opening the "Paste Special" option, do not select the options after it, click "Paste Special" directly, and the Yinghui system will pop up a "Paste Special" dialog box.

6. Under the dialog box, find the "Operation" column and select the option "None" to change it to "Multiply".

7. After the selection is completed, click OK, and the result of turning all the positive numbers into negative numbers will come out.

Method: 1. Open Excel**, enter "-1" in an empty cell, and copy.

2. Select the ** that needs to be changed to "negative value", and click "Paste" - paste selectively.

3. In the pop-up page, select "Multiply" under Operation, OK.

4. At this time, all the values are multiplied by "-1".

A1 cell --- set cell formatting--- number--- custom formatting ---0

b5 =abs(a10) takes the absolute value.

By doing this, my debit also becomes negative.

Set it in the cell, customize.

1. Find Excel on the desktop, double-click and open it.

2. Create a new ** Xiang, named "Negative Input", and make preparations.

3. In the excel sheet, directly enter -20, and the display result is a negative number -20. The negative sign is the key to the right of the horizontal row of 0 on the keyboard, which is entered in Chinese.

4. At the same time, you can also enter (20) in the excel cell, and the result displayed by pressing the enter key is also in the form of negative numbers.

In this case, the calculation error set by the excel worksheet is too large, and you only need to prepare a ruler to reduce the value of the error. In Excel 2016, the specific operation method is as follows:

1. Open the excel sheet and click on the file option in the upper menu bar.

2. In the file interface, click the "Option Empty Roll" in the lower left corner.

3. In the excel option box, click the formula to set it.

4. Set the maximum error to ", and finally save the settings.