Excel Number formats (auto rounding)

  CAS123 13:24 30 Sep 09
Locked

I have a list of numbers 16 digits long. My excel sheet keeps rounding the numbers up or down to the nearest 10. I want to show the actual number. I can not find how to change this.

  VoG II 13:47 30 Sep 09

Excel will only display numbers up to 15 digits.

If you want to display 16 characters, first format the cells as Text then enter the numbers.

  CAS123 14:00 30 Sep 09

Thank you, have spent too much time trying to figure out myself.

This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac