Whacky Cell Number Calculation

J

Josiah

When I enter a long string of numbers (Such as an account number) I en
up with an exponential format such as 7.71412E+15...

How do I turn this off?!?!
 
F

Frank Kabel

Hi
you can format the cell with a custom format like
000000000000000

Note: Excel only supports 15 significant digits. If your account
numbers consist of more digits (as your example indicates) store them
as 'Text'. To do this either
- format the cell prior to entering with the 'Text' format
- enter your data with a leading apostrophe. e.g.
'1234567890123456
 
Top