Cell Format

Giganews Newsgroups
Subject: Cell Format
Posted by:  Alan Potter (alan.pott…@bris.ac.uk)
Date: Thu, 30 Oct 2003

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.

Replies