Solved

Big Number in Excel

Posted on 2013-06-16
5
362 Views
Last Modified: 2013-06-17
Hi,

Is there any method by which I can save a big number in Excel without getting its value changed. For example, my number is:

26138E109

As I write this number in the cell, its value changes to 2.6138E+113.

Yes, if I save it using single quote ' it works fine. But is there any other method?

Sanjay.
0
Comment
Question by:sanjay-gandhi
  • 3
  • 2
5 Comments
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
Comment Utility
Are you suggesting you want to see all 115 digits? Isn't that making the number hard to read?

Kevin
0
 
LVL 81

Accepted Solution

by:
zorvek (Kevin Jones) earned 150 total points
Comment Utility
If you are entering account numbers or something like account numbers then format the cells as Text and you won't have to enter the single quote.

Kevin
0
 

Author Closing Comment

by:sanjay-gandhi
Comment Utility
Well, these are only 9 digits. Which 115 digits are you talking about?
Format cell as text does not work always though.
However, single quote appears to be the only answer.
Thanks.
0
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
Comment Utility
>Well, these are only 9 digits. Which 115 digits are you talking about?
26138E109 is the value 26,138 with 109 zeros to the right.

>Format cell as text does not work always though.
Yes it does. A cell formatted as text displays any value exactly as it was entered.

>However, single quote appears to be the only answer.
No, it isn't. You can format the cells as Text.

Kevin
0
 

Author Comment

by:sanjay-gandhi
Comment Utility
Ok, this is new to me that E109 means 109 zeroes after the number.
Yes, tried this works fine. Thanks.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now