Excel Number formats (auto rounding)

  CAS123 13:24 30 Sep 2009
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 2009

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 2009

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

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

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

See mcbess's iconic style animated for Mercedes-Benz

iPhone X news: Release date, price, new features & specs

Black Friday 2017 : date, sites participants & bonnes affaires