x******n
发帖数: 173 | 1 For example,
If I have 0.005462, 1.23456, et.
I want them to be .0055 and 1.23 respectively, what should I do in excel?
Thanks a lot. | p********a
发帖数: 5352 | 2 format cells and keep the # of digits you need | x******n
发帖数: 173 | 3 But this method can only keep the selected number of digits after the
decimal point, isn't it?
If I have a number of 0.00345, how can I get 0.0035?
【在 p********a 的大作中提到】
: format cells and keep the # of digits you need
| p******a
发帖数: 41 | 4 format to scientific-formatted text with 2 sig. digits, then convert texts
back to numeric:
=value(text([cell reference here], "0.0E+00")) |
|
