I'm trying to create a workbook capable of doing the maths behind a
biological calculation. The results are very low (x10 E-6) and i would like
to report this with the correct scientic prefix (pico- nano- etc...) is this
possible in excel?

eg result comes as 3.41323E-06

i would really like 3.41 pMol

i can get it down to 2 decimal places but i can't set a rule to 'replace
e-06 with pMol'