Excel's operation content to display cell data in a specified format

How to customize cell data format in Excel? When using Microsoft Excel, you often need to display cell data in a specific format, such as currency, date, or percentage. PHP editor Strawberry will introduce you how to easily customize the cell data format to make your data more readable. By following this guide, you'll be able to clearly present your data in the format you need.

First select the data area to be edited.

Right mouse button [Format Cells].

Select [Custom] at [Number] - [Category].

Find the format you need at the type.

If not, manually enter the custom format in the input box, such as 000-00000-0000.

After clicking OK, I returned to the Excel table and found that the data had become separated in the specified format.

The above is the detailed content of Excel's operation content to display cell data in a specified format. For more information, please follow other related articles on the PHP Chinese website!