Current location - Training Enrollment Network - Mathematics courses - Why can't the number 0 be displayed after being entered in an excel worksheet?
Why can't the number 0 be displayed after being entered in an excel worksheet?
This is excel, and the zero value is set to no ... Take excel20 13 as an example.

The operation of other versions is basically the same.

① Click "File"

② Click "Options" on the switched screen.

(3) Click "Advanced" to see if "Show zeros in zero value cells" is selected.

If not, please check and click "Save". Displays zeros in the file.