So 132.468 & -186.0152 & 167.03... I don't want to have click format button every time to adjust it to see the whole number.

1 Answer 1


Format cells as Format > Number > Automatic to show all decimals by default.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.