|Subject:||Re: Cell Format|
|Posted by:||Andy B (email@example.com)|
|Date:||Thu, 30 Oct 2003|
Try using a custom format of 0.00p, or 0.0m
"Alan Potter" <alan.pott…@bris.ac.uk> wrote in message
> Does anyone know an easy way to format cells such that
> they have an engineering appearance?
> ie. 10.00M or 5.14p
> I would like to format a worksheet of results such that
> they display 2dp. and then use the scientic letter
> representation as above (eg. T,G,M,K, ,m,u,n,p etc.)
> Would I need a macro to do this for me?
Cell Format posted by Alan Potter on Thu, 30 Oct 2003