v*********u
发帖数: 10464 | 1 问个白痴问题，关于excel显示数字的问题
当数字是10位数的时候，正常显示
当数字超过10位数的时候，excel的框框里面就省略显示了，能让这个省略变成全部显
示吗？
谢谢了 | L*********h
发帖数: 274 | | v*********u
发帖数: 10464 | | D****P
发帖数: 229 | 4 Microsoft Excel retains 15 significant digits. To display all 15 digits, you
must use a number format (custom or built-in) other than General. The
General number format displays up to 11 numeric characters, with the decimal
point counting as a numeric character. Therefore, if the number contains a
decimal point, Excel can display up to 10 significant digits, but if the
number does not contain a decimal point, Excel can display up to 11
significant digits Adding more numbers to the left of the decimal point
causes the number to appear in exponential notation. |
|
