September 03, 2020
August 26, 2020
August 07, 2020
September 14, 2020
However, they usually getting wired when you log in to excel with all kinds of mistakes. (Eg. Missing 0 at the front)
Don't worry! Keep reading for tricks to prevent such things happened from the beginning!👉
First of all, the reason why Excel is acting so crazy is that the software automatically treating those long large numbers as a mathematical number instead of text.
Excel will either add decimals after the number or round the number up and omit the numbers at small digits.
Luckily, simple action in advance saves all the troubles.
Or, if you need to change the format for a couple of cells only, you can simply add a " ' " in front of the numbers.
In this way, Excel will recognize a series of numbers as text, and the quote mark will be invisible for view. Guess what, which also means...
Direct input within the cells can differ from the actual result(view)!
Come on, Let's think outside of the box to achieve an even more convenient way to work! For example👉
Thank you for staying with WPS. Hope to see you in a bit!