Whacky Cell Number Calculation

  • Thread starter Thread starter Josiah
  • Start date Start date
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?!?!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to write 1234567890123456789 into a cell with number format 3
Protect Number Format Only 6
automatic time formatting 3
Creating numbers for an exponential growth curve 2
Excel Custom trendlines and R^2 values 0
Annoying problem inserting numbers into cells 3
Numbers showing Up Centered in Cell ? 1
Date versus number format 6

Back
Top