Home  >  Article  >  Software Tutorial  >  How to change the date into a pound sign in Excel

How to change the date into a pound sign in Excel

WBOY
WBOYforward
2024-03-20 11:46:181788browse

php editor Baicao teaches you how to solve the problem of Excel date turning into a pound sign! When excel displays the date as "

#", it may be because the cell width is not enough or the date format is incorrect. Workaround: Adjust the cell width or change the date format. Steps: Select the date cell, right-click the "Format Cell" option, select the appropriate date format or manually adjust the cell width to solve the problem. Come and try it!

1. First, we put the mouse on the column width line between columns AB, double-click and adjust the column width, as shown in the figure below. How to change the date into a pound sign in Excel

 

2. After the column is widened, we find that numbers are displayed in the cells instead of dates. This is definitely incorrect, then we should check the cells. The grid format is as shown below. How to change the date into a pound sign in Excel

 

3. Click the "Number" option in the "Home" tab, and click "Other Number Format" in the drop-down menu, as shown in the figure below. How to change the date into a pound sign in Excel

 

4. Select "Date" in the "Set Cells" dialog box, select the date format on the right, and click OK, as shown in the figure below. How to change the date into a pound sign in Excel

 

5. Or directly select "Short Date" or "Long Date" in the date group drop-down menu, as shown in the figure below. How to change the date into a pound sign in Excel

 

6. After operation, the date will be displayed, as shown in the figure below. How to change the date into a pound sign in Excel

 

###The editor will teach you all how to deal with turning dates into hash marks in excel. There are actually many ways to process data in excel software. We have learned these functions. , it can really play a vital role in our data statistics, and it can also improve our work efficiency. ###

The above is the detailed content of How to change the date into a pound sign in Excel. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:huke88.com. If there is any infringement, please contact admin@php.cn delete