Solved

Big Number in Excel

Posted on 2013-06-16
5
398 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)
ID: 39252314
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
ID: 39252315
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
ID: 39252422
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)
ID: 39253328
>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
ID: 39253941
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: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

856 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