Need vba code/formula to find exponential value

**Karthik Sen** · 02-02-2012, 02:30 PM

Hi All,

I need a Vba code/ formula to find whether a cell in a particular column has exponential value

**tigeravatar** · 02-02-2012, 03:10 PM

Karthik Sen,

I'm afraid I don't know what you mean.
Do you mean, "is the cell equal to e^# (Where # is a whole number)?"

If not, then what do you mean "has exponential value"? What is the logic you would like to use to determine yes/no?

**Karthik Sen** · 02-03-2012, 02:28 PM

Originally Posted by tigeravatar

Karthik Sen,

I'm afraid I don't know what you mean.
Do you mean, "is the cell equal to e^# (Where # is a whole number)?"

If not, then what do you mean "has exponential value"? What is the logic you would like to use to determine yes/no?

My apologies...its actually not exponential..i need to find whether there are any cells in a particular column which is in "Scientific" format. ex: 7.58E+09

**tigeravatar** · 02-03-2012, 02:38 PM

If a cell is formatted as general, but the length of the number exceeds the width of the cell, the number will show as being in scientific format, even though the cell is actually in General format. This makes it difficult to distinguish between cells that are actually formatted as scientific, and cells that are general, but show scientific notation to save display space.

If the cells you're looking for are actually formatted as scientific, you can search for cells of that format: http://office.microsoft.com/en-us/ex...005200214.aspx

If the cels you're looking for are formatted as general, but display scientific notation to save display space, you could use conditional formatting to highlight all cells larger than a value, for example: >1e9