Win7 system Excel table display #### What is going on?

Win7 system Excel table display #### What is going on?

1. The value, date, or time entered into the cell is too long, or the result of the formula is too long, resulting in insufficient column width;

2. The datetime formula of the cell is generated. A negative value;

The solution is as follows:

1. Adjust the column width. Use the mouse to drag the entire column width to the right, or use the "column width" under the cell"Format" function to adjust the column width;

2. Change the font size to reduce the cell size. The content inside to fit the column width;

3, change the number format of the cell, for example, you can reduce the number of decimal places after the decimal point;

If the cell date is negative due to a negative number The solution is as follows:

1. The input time and date must be guaranteed to be positive;

2. If the date and time are subtracted, the formula must be guaranteed to be correct. ;

3. If the formula is correct, but the result is still negative, you can change the format of the value in the cell, such as non-date or non-time;