Cell Format

  • Thread starter Thread starter Alan Potter
  • Start date Start date
A

Alan Potter

Hi,

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?

Thanks.
 
Unfortunately XL does not like this too much.
My solution so far, but not the best....

I multiply everything on my spreadsheet by 1E12
then I can use up to two condtions in the custom cell
format. XL cannot handle more.
So now everything <0 is marked in red, everything <1000
is 000.00p and for everything else I use ##0.00,"n" which
gets rid of the first 3 digits then writes an "n".

As you can see, this solution can only disply p & n. it
cannot deal with larger or smaller numbers. (currently
anything smaller is marked in red, and anything larger is
still shown as nano.

Alan.
 
Back
Top