How do I make Excel stop rounding off my numbers that are 16 digi.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top