How Excel converts formula data into text or numbers;
1. In the excel worksheet, the result is calculated by the formula. Sometimes you need to know the calculation process of this result, and you can use the formula display function of excel.
2. You can directly click to display the formula, or press f9 to select the formula of the cell. Only the formula calculation process can be displayed here, not in text format. ;
3. Copy the formula, paste it selectively, and store it in text format. Although this operation can be achieved, it is still not fast enough to convert the formula into text format.
4. Select the cell area where the formula is located, open the square grid in the excel plug-in, find the value drop-down, and select the formula conversion book. ;
5. Select formula to convert text for confirmation, and quickly convert the formula into text format for storage with one key, so that you can not only know the calculation results, but also see the calculation process.