Method One:

1. Add English single and double quotation marks in front of a string of numbers, remember to enter single and double quotation marks on the keyboard under the English state of the input method;

2. In this way, the numbers will be automatically converted to character types and will not be displayed in scientific notation.

Method Two:

1. You can set the format after “Wrap”, and set the cell of the ID card area to “Text”;

2. Or right-click the corresponding cell to open the menu and select “Format Cell”;

3. Select “Text” in “Category” and click OK;

4. Then it will not be displayed in the “numeric” type.

Excel input ID number become 0

Merge same items in Excel?

You can use Excel to do the same kind of summation.

1. Open the EXCEL file and find “Subtotals” in the “Data” tab.

2. Click “Subtotal”, the computer will automatically select all areas of the workbook.

3. In the pop-up dialog box, select “Category Field” and “Summary Method” as “Sum”.

4. According to the above steps, the total sum can be calculated.

Functions and Shortcuts

Operation steps/methods 【Method 1】

1. Open the EXCEL file and find “Subtotals” in the “Data” tab.

2. Click “Subtotal”, the computer will automatically select all areas of the workbook.

3. In the pop-up dialog box, select “Category Field” and “Summary Method” as “Sum”.

4 According to the above steps, the total sum can be calculated.

END Notes/Summary

Find Subtotals in the Data tab.

The computer will automatically select all areas of the workbook.

How to batch set book titles in Excel?

Recently, some friends have asked the editor about how to set the title and number of books in batches in excel? The following will bring you the sharing method of the process of setting the title and number of books in batches in excel. Friends who need it can come to understand.

Excel input ID number become 0

How to set book titles in batches in Excel?

1. Open the file and select all the book titles.

2. Press Ctrl+1 on the keyboard to pop up the “Format Cells” window.

3. Select “Custom”.

4. Enter “@” in “Type”. Then click “OK”.

How to modify the table data display in Excel?

When using excel to edit the table, how to modify the table data display? Next, the editor will bring you the modification method of excel table data display, friends in need don’t miss it.

1. First, in excel, click the cell you want to edit, and find the filter button in the start tool

2. Then, you can see that an inverted triangle symbol appears in the lower right corner of the name cell

3. Next, click the mouse to open the window, and check the data name you want to display in the content filter column.

Recommended reading:

GB WhatsApp Download

How can you tell if someone is pretending you’re offline on Fouad WhatsApp?

Leave a Reply

Your email address will not be published. Required fields are marked *