Re: Cell Format

Giganews Newsgroups
Subject: Re: Cell Format
Posted by:  Andy B (
Date: Thu, 30 Oct 2003


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


"Alan Potter" <alan.pott…> wrote in message
> 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.


In response to

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