What is this value means 1 845E-07 in excel

0 votes

I'm using interop services to read an excel sheet from C#. One of the cells on my sheet has a value of 0.00. Yet, at runtime, when I verify the value of that cell in C# code, I am receiving the number "1.845E-07". When I checked the Excel sheet and right-clicked on that cell, I saw the value "1.845E-07" in the sample area. How is the value exacted? Please assist me. I am unable to give the code here due to its size. this sentence:

if (Convert.ToString(((Excel.Range)worksheet.Cells[iRowindex, colIndex_q10]).Value2) != string.Empty)
{
    drRow[dtSourceEXLData.Columns[constants.Floor]] = ((Excel.Range)worksheet.Cells[iRowindex, colIndex_q10]).Value2.ToString();
}

Same problem with Date cell "39448". what does this mean?

Nov 6 in Others by Kithuzzz
• 20,660 points
37 views

1 answer to this question.

0 votes

The precise value, expressed in scientific notation, commonly referred to as exponential notation, is 1.84E-07.

0.0000001845 is equal to 1.845E-07. Unless you change the formatting of the cell to display more decimals, Excel will display a number that is very near to 0 as 0.

However, C# will retrieve the cell's actual value. When converting tiny values to strings, the ToString function uses the e-notation.

Alternatively, if you don't want to utilize the e-notation, you can specify a format string.

answered Nov 6 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

What is this weird colon-member (" : ") syntax in the constructor?

Foo(int num): bar(num) In C++, this is known as a Member Initializer List. Simply put, it sets the value of your member bar to num. There is a significant difference between initializing a member with the Member initializer list and assigning a value to it within the function Object() { [native code] } body. When you use the Member initializer list to initialise fields, the constructors are only called once, and the object is constructed and initialised in a single operation. If you use assignment, the fields will be initialised with default constructors and then reassigned with actual values (via the assignment operator). As you can see, there is an extra overhead of creation and assignment in the latter, which may be significant for user defined classes. Cost of Member Initialization =Object ...READ MORE

answered May 27 in Others by Damon
• 4,960 points
173 views
0 votes
1 answer

Excel trim function is removing spaces in middle of text - this was unexpected (?)

Create a UDF that uses VBA's version ...READ MORE

answered Oct 18 in Others by narikkadan
• 37,660 points
48 views
0 votes
0 answers

What is the formula to keep first two words in a cell over excel?

I want to maintain the first two ...READ MORE

Nov 2 in Others by Kithuzzz
• 20,660 points
27 views
0 votes
1 answer
0 votes
1 answer

Turn values into scientific notation in R

Consider the below vector: a<-c(0.1324,0.0001234,234.21341324,09.324324) You can convert it ...READ MORE

answered Jul 19, 2018 in Data Analytics by DataKing99
• 8,240 points
10,492 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
454 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,100 points
405 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,100 points
3,384 views
0 votes
1 answer
0 votes
1 answer

What is the better API to Reading Excel sheets in java - JXL or Apache POI

Here are the things where both APIs ...READ MORE

answered Oct 9 in Others by narikkadan
• 37,660 points
215 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP