Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jane
 
Posts: n/a
Default 16 digits

I need to type numbers that have 16 digits. Excel drops all digits after 15.

My format is set to Number with 0 decimal places, but I have also tried a
custom format with 16 zeros.

How can I make that 16th digit hold?

Jane
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mistery digits on excel Bewilder Excel Discussion (Misc queries) 2 October 5th 05 06:28 PM
excel floating digits error Bewilder Excel Discussion (Misc queries) 3 October 5th 05 05:56 PM
Mod 10 & 11 Pablo Excel Worksheet Functions 13 August 10th 05 11:39 AM
Help - Any number longer than 12 digits turns to scientific and ro LMH_VT Excel Discussion (Misc queries) 3 July 17th 05 03:58 PM
Least number of digits in Y-axis labels Charley Kyd Charts and Charting in Excel 9 February 6th 05 03:03 PM


All times are GMT +1. The time now is 12:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"