getting the exponent and mantissa from scientific format

[Barfbagger]

for a list of numbers in fixed decimal format I need to get the exponent and mantissa of the maximum value in scientific format so that I can calculate a scale for a chart in VBA. Either a function or VBA would be OK

 

[Damon Ostrander]

Hi Barfbagger,

Say for example your number is in cell B4. To get the exponent:

=INT(LOG(B4))

Let's now say that this formula is in cell C4. Then to get the mantissa:

=B4/10^C4

 

[Barfbagger]

Thanks,

 

[moodyoldblue]

Brilliant solution. Thank you.