Fool only to remember the TEXT function, smart people are using this trick! _ Accounting for the accountant - Certified Public Accountant | Registered Tax Accountant | Accounting Title | Senior Accountant | Accounting

TEXT function Variety of God Jun, the text of the king said, unpredictable. That is simple to lie to you, that is difficult to lie to you, master the method, but also learn. This function if it is really difficult to understand, it is difficult, it is difficult. Why do you say this way? A single date, enough for you to halo for three days, do not believe you to see. Use the formula: = TEXT (A2, "0-00-00") 2. Convert the standard date to 2 months on 2 months. Use the formula: = TEXT (A2, "e-mm-dd") 3. Convert the date to day of the week and several. Use the formula: = TEXT (A2, "aaaa") = TEXT (A2, "aaa") "Stop, you have finished, you go on like this, I'll show you." If you go to remember these, not halo strange, really smart people are good at using external forces. Only a fool to go by virtue of their poor memory to recite these. How does this function learn? In fact, this function is white, that is, set the cell format. As long as you set the cell format, you can grasp the usage of this function. Now suppose that you do not know how to say on Wednesday, Luzi step by step to teach you to use. Step 01 Set the cell format to Wednesday. Step 02 in the custom cell format, you can see the code: [$ - 804] aaaa; @ Step 03 copy the code out into the TEXT function second parameter. As a beginner, you do not have to ignore the meaning of this code, used to use it. After the opportunity to study in depth, Luzi told you to explain the meaning of each of the code. Remember, you use the TEXT function, first set the cell format, and then copy the code over, do not rote! When reading, some people read the words or two words can be recited out, and some people read a hundred times to recite it. Smart is a reason, more important is the method.