Excel cells formatting

[sabavno]

Hi,

A quick question....my cell value appears as 1.112E+11, when I double-click on it, it becomes 111200201529. What is the reason for the number field appear as something like 1.112E+11?


Thanks

 

[Dreamboat]

Format the cell as Number, with no decimals. It is formatted as General now, I'm sure. Anne Troy

http://www.TheOfficeExperts.com

 

[Dreamboat]

What is in the cells now? Anything?
You could use conditional formatting that if the cell is blank, it has a fill color. Anne Troy

http://www.TheOfficeExperts.com

 

[sabavno]

Yeah, it is formatted as general. But this same column also has the values that include text, should I still format the whole column as a number?

 

[Hasit]

You can - but it depends on what you are doing with that data that may determine what format yuo use.

 

[Tazcat]

When the format is General, and the number is longer than the column is wide, excel will usually display numbers in notation form. In the number 1.112E+11, "E+11" means exponent of 11, or that the decimal is really 11 places to the right. Changing the cell's format to a number type may solve the problem, but if you get a result like "#######" it means that the column needs to be wider, or the font size smaller, so that the entire value can show. Setting an entire column format to a number type will not alter text strings.