What is excel (1.66E06)

[Raju Chacha]

Hi friends, I have the long time experience for using the excel, but somewhere I have seen or heard the statement excel (1.66E06), so I just want to know what it means and what are the use of this excel (1.66E06). So if you guys have any of the information or any of the suggestion then please let me know.

[Panop]

Even I was also confused about this, but however finally I get the ideas about this excel (1.66E06). This is scientific notation:

1.66E06 =1.66*10^6 = 1660000

[GaganjyotTechie]

I assume you mean 1.66E+06. It is called scientific notation. It is read "1.66 times 10 to the 6th", meaning 10 multiplied by itself 6 times (1000000). The actual numeric value can be anywhere between 1655000 and about 1664999.99999999.

[DanielaA]

Implicit in your question might be "why does the number appear this way?" and "how do I avoid it?” Presumably, the cell is formatted as Scientific with 2 decimal places.
Click on Format > Cells > Number.
If you want a different format, select General or perhaps Number with some number of decimal places. As for how it got that way without your knowing it, perhaps you imported data that included the number written as 1.66E+06.