How to use Excel single quotes with Excel single quotes

The data entered in the Excel cell generally defaults to the “General” type. In actual use, how do we deal with unconventional situations? I use the single quotes ' in English. The following is the use of Excel single quotes shared by Xiaobian. 1. Input of leading zero data. If you enter “001”, the system will change to “1” when you enter “001”. You can enter the single quotes in English status “'”, then enter 001. At this time, the system automatically converts “001” into a "text” type, but can still operate with values. 2. Input of lowercase logic constants. If you enter “true”, the normal input "true" will automatically convert to uppercase, then you can enter the English single quotes, then enter "ld"; true & rdquo;. At this time, the system also converts the content into a text type, but it can still be used as a logical constant, such as using the not function. 3. When entering date data, we also enter the single quotes of the English state before, and the system will automatically convert to the text type. When it is added with 0, the value obtained is ““DATEVALUE()” function value The same, which is the number of sequences corresponding to this date.