Shulou(Shulou.com)06/01 Report--

This article introduces the knowledge about "how to solve the problem of excel cell ######". In the actual case operation process, many people will encounter such difficulties. Next, let Xiaobian lead you to learn how to deal with these situations! I hope you can read carefully and learn something!

Cell ###appears in two cases

1, because the width of the data exceeds the width of the cell display is incomplete.

This situation is relatively simple, reduce the font size or widen the cell width.

Cell too wide

2. The wrong cell data format is selected.

This is mainly the case when you enter more than the default date range in the cells of the date format.

Number corresponds to date format

In Excel, the date range is from January 1, 1900 to December 31, 9999, and the corresponding values are 1 to 2958465, that is, in the date format, the corresponding values can be converted to corresponding dates. When the value entered exceeds the range of 1-2958465, Excel cannot match the corresponding date and displays "####". For example, mobile phone numbers and ID numbers are relatively easy to encounter this problem.

So how to solve this problem, it is relatively simple, just change the format of the cell to "general" can be.

Number changed to regular format

"Excel cell appears #######how to solve" the content is introduced here, thank you for reading. If you want to know more about industry-related knowledge, you can pay attention to the website. Xiaobian will output more high-quality practical articles for everyone!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.