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

Data garbled in general is rarely encountered, if that happens accidentally on your body, how will you solve it? Here are a few different data garbled problems and solutions that I summarized for you.

First, Excel table width is not enough, garbled situation will occur

Problem 1: Form width is too narrow, data congestion is garbled

Solution: Just widen cell A a bit.

II: Data exceeds eleven digits, and garbled code occurs.

Question 2: If the data exceeds 11 digits or more, there will be random code.

Solution:

1. Click the right mouse button and find Set Cell Format.

2. Find the Custom area and select Custom Type 0.

3. The result of the solution.

Well, today's Excel garbled situation tips to share here, there are friends in need of collection, forwarding, comments.

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.