Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 425
  • Last Modified:

Big Number in Excel

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
sanjay-gandhi
Asked:
sanjay-gandhi
  • 3
  • 2
1 Solution
 
zorvek (Kevin Jones)ConsultantCommented:
Are you suggesting you want to see all 115 digits? Isn't that making the number hard to read?

Kevin
0
 
zorvek (Kevin Jones)ConsultantCommented:
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
 
sanjay-gandhiAuthor Commented:
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
 
zorvek (Kevin Jones)ConsultantCommented:
>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
 
sanjay-gandhiAuthor Commented:
Ok, this is new to me that E109 means 109 zeroes after the number.
Yes, tried this works fine. Thanks.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now