Re: Cell Format

Giganews Newsgroups
Subject: Re: Cell Format
Posted by:  Andy B (andy@removethisbit.dawsons.co.uk)
Date: Thu, 30 Oct 2003

Alan

Try using a custom format of 0.00p, or 0.0m

Andy.

"Alan Potter" <alan.pott…@bris.ac.uk> wrote in message
news:068301c39efd$c2ed9350$a00128…@phx.gbl...
> 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

In response to

Cell Format posted by Alan Potter on Thu, 30 Oct 2003