Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Aida
 
Posts: n/a
Default How do I make Excel stop rounding off my numbers that are 16 digi.

Using Excel 2003... I want to type in a 16 digit number without it rounding
of the last digit. In example I type 6038060611469583 and I get
6038060611469580. I give the number enough space and I have tried to go to
format and select custom but I cant seem to type in a format that would avoid
my number from rounding off.
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
Excel supports only 15 significant digits. As I doubt you want to
calculate with this number try one of the following:
- preformat the cell as 'Text'
- enter the value with a leading apostrophe. e.g.
'6038060611469583

--
Regards
Frank Kabel
Frankfurt, Germany

"Aida" <Aida @discussions.microsoft.com schrieb im Newsbeitrag
...
Using Excel 2003... I want to type in a 16 digit number without it

rounding
of the last digit. In example I type 6038060611469583 and I get
6038060611469580. I give the number enough space and I have tried to

go to
format and select custom but I cant seem to type in a format that

would avoid
my number from rounding off.


Reply
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
How do I make a 3-dimensional plot in Excel? John W. Mordosky Charts and Charting in Excel 6 April 3rd 23 06:58 PM
Excel converts Mapped drive to UNC - How to stop? Fred Links and Linking in Excel 1 January 20th 05 01:24 AM
in excel why do numbers entered get divided by 100? roger bemused Excel Discussion (Misc queries) 1 December 4th 04 02:05 AM
In excel and a pivot table - how can I stop it displaying (blank). Mansel Excel Discussion (Misc queries) 1 December 2nd 04 01:55 AM
How do I stop the Reviewing toolbar from showing up in Excel? RickKel Excel Discussion (Misc queries) 2 November 26th 04 06:37 PM


All times are GMT +1. The time now is 09:53 AM.

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

About Us

"It's about Microsoft Excel"