how solve this error

Question

1.00/5 (3 votes)

See more:

hi friends , my excel file creating programme output data something like this.

1.10018E+12
1.10013E+12
1.8001E+13

how do i fix this and get appeared actual data.

Posted 10-Jan-16 18:02pm

Member 12235586

Add a Solution

Comments

Wendelius 11-Jan-16 0:13am

The the cells in Excel. Changes are that the data is correct but if the column is too narrow, Excel will show large numbers in that format. So click in a cell and see what it actually contains

Member 12235586 11-Jan-16 0:19am

is there were no option to display that contents as a normal data??

Sergey Alexandrovich Kryukov 11-Jan-16 2:32am

What problem? What is "normal"? What is not not normal in your numbers?
—SA

Member 12235586 11-Jan-16 4:49am

my actual value is 3100151196920.but display value is 3.10015E+12. i want to display 3100151196920 and as normal data i mentioned that value.

Sergey Alexandrovich Kryukov 11-Jan-16 9:50am

This is the same value. I'm sure you don't understand what is "value". Sorry.
—SA

[no name] 11-Jan-16 16:32pm

I think defining "same" needs some explanation. Not knowing that the Background of the question is Excel Display stuff I don't think that 3.10015E+12 is _equal_ to 3100151196920 :-)

Sergey Alexandrovich Kryukov 11-Jan-16 17:09pm

Yes, I did not even try to explain anything, because this forum is not the best place for learning from scratch (a rough quote). :-)
I did not even look for comparison of those numbers. The problem is the principle one: understanding of what number is. This is really about it, nothing else.
—SA

[no name] 11-Jan-16 17:20pm

*lol* this Forum is a very good place to learn. I learned a lot from you and also from others, incl. OG ;)

Sergey Alexandrovich Kryukov 11-Jan-16 18:04pm

Thank you for your nice words, and — good for you, even though I don't know how it's related to the present question... :-)
—SA

Patrice T 11-Jan-16 1:54am

This is actual data.
You should learn the display formats.

Sinisa Hajnal 11-Jan-16 2:46am

Increase the width of the column. Or right click on the cell and select format cell, select "correct" format for the cell.

Member 12235586 11-Jan-16 4:50am

is there any option to change that value to numaric in programaticaly

Philippe Mori 11-Jan-16 12:50pm

It depends on how you create the file but you give no such informations.

Patrice T 11-Jan-16 15:52pm

The 3 values in your question are numeric already.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dj@y · Answer 1 · 2016-01-11T21:07:00

Solution 3

please set the cell format as Number format instead of general cell format.
It will solve your problem.

Posted 11-Jan-16 21:07pm

Dj@y

AyushMaheshwari · Answer 2 · 2016-01-11T01:36:00

Solution 1

Change column to number with decimal places 0.

Posted 11-Jan-16 1:36am

AyushMaheshwari