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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

The updated 'Corel Painter inside Photoshop' plugin ParticleShop offers new brushes

Best running headphones | Best sport & fitness headphones: 4 brilliant pairs of wireless…