How to solve the Excel brackets become a negative sign? Excel brackets become a negative solution tutorial

Excel is a computer software that we often use in daily life. If you learn Excel well, you can greatly improve the efficiency of your work to a certain extent. We will encounter various problems in the process of using Excel. For example, if you input () here, it will become - such a situation, then what should be done?

1. Assume that we enter the word (18) in any Excel cell, and then we press the Enter key. This time it was originally displayed “(18)” The cell suddenly became "<;-18”, which is what we said.

2, this is mainly because in the regular input, the () in Excel is exactly the same as -, this will also cause this situation, we will see the cell format, it will be displayed as “ -18 & rdquo; style

3, then we have to delete the contents of the original cell, turn it into a text format, we first set the cell format to text, then enter (18), press Enter, find the display or "(18)”

4, or we can use the shortcut, enter "ldquo;‘(18)” in the cell, input before adding An & lsquo; symbol means that the cell format is changed to the text format, achieving the same effect as above