How Excel Makes Payroll Content into Text in SMS Format

One is to copy and paste directly, copy or cut the contents of excel to the clipboard, and then open the TXT text and paste it. Second, when saving an EXCEL document, select the following save types and find the file type with the suffix (*txt).

The specific steps are as follows:

1. First find out the number column that needs to be converted into text format, such as column A in the figure below, and then enter the formula "=TEXT(A2," 0.00 ") in the blank column, such as column B, where B2 corresponds to A2, and" 0.00 "represents two digits after the decimal point. If the decimal point is 1 digit, you can write "0.00".

2. After writing the formula, directly click "Enter" to display the result, and then place the mouse in the lower right corner of B2 border.

3. When the mouse is in the lower right corner of the B2 border, a "+"sign will appear, that is, double-click the left mouse button to drop it down, and then column B will display the value relative to column A. ..

4. Then select all series in column B, copy and paste, and a similar paste icon will appear in the lower right corner. Click this icon, and then click the value 123.

5. At this point, all the numbers in column B are displayed in text format, and then all the data series in column B are copied and pasted into column A, and then all the numbers in column A are deleted, so that all the numbers in column A are converted into text format.

So everything is fine.