Array numberformat: need to change

[HankJ]

Hi
I'm learning about splitting and joining.
I have a cell, which is a dose response of concentrations in scientific notation.
I have got to the step where my array is filled with each concentration.
I now need to change the format from 1.0E-6 to 0.000001
I've attempted:

WrdArray(i) = Format(WrdArray(i), "General")

and I get a Type mismatch error

WrdArray(i).NumberFormat = "General"

and I get invalid qualifier...

There must be a way.

Many thanks

Hankj

 

[HankJ]

That will be due to Excel trying to decide itself what format to use. Try adding in this line of code where shown.

  With Range("C1:D1").Resize(UBound(a))
    .NumberFormat = "@"
    .Value = a

Hi Peter,

Diamond Dog! Works a treat.

Many thanks

Now off to work out how L and U bounds work.

Best wishes

Hank

 

[Peter_SSs]

Works a treat.