How to add the same numbers to one column in Excel

How to add the same numbers to a column in Excel

1. First, we open a new excel table and open it.

2. Then, we can create a data table at will and write the numbers casually for easy demonstration.

3. We select the data we need to process, right-click the mouse and select "Format Cells"

4 , We select "Custom" in the category, enter the number "100" in the type, and you can see clearly that there is a number "0" added after the number, and there is a preview effect on it.

#5. We can confirm the actual effect. The actual value is still 9.

For more Excel-related technical articles, please visit the Excel Basic Tutorial column!

The above is the detailed content of How to add the same numbers to one column in Excel. For more information, please follow other related articles on the PHP Chinese website!