Custom Format Cell

Hi, I am looking for way to custom format cell to read 1.511B or 1.511M
as: 1B 1M (also would like example for 1.5B or 1.5M). thanks

already have cell formatted as Number, works with other work column with e.g.:
=IF(OR(CE138=0,BZ138={0,"n/a"}),"",(LEFT(BZ138,LEN(BZ138)-1)*IF(RIGHT(BZ138,1)="b",10^9,1)/CE138*$BV$4))

Just looking for custom formatting such as: ##0.0*

Try:

=SUMIF(H1:H12,"<"&TODAY()-60,I1:I12)

Adjust to suit your own ranges.
--
HTH

Sandy
In Perth, the ancient capital of Scotland

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk


"nastech" <nastech@discussions.microsoft.com> wrote in message
news:E9E5ED82-28B4-4FFB-AD3F-6F339A641AB2@microsoft.com...
> Hi, I am looking for way to custom format cell to read 1.511B or 1.511M
> as: 1B 1M (also would like example for 1.5B or 1.5M). thanks
>
> already have cell formatted as Number, works with other work column with
> e.g.:
> =IF(OR(CE138=0,BZ138={0,"n/a"}),"",(LEFT(BZ138,LEN(BZ138)-1)*IF(RIGHT(BZ138,1)="b",10^9,1)/CE138*$BV$4))
>
> Just looking for custom formatting such as: ##0.0*

Woops! Replied to the wrong post - sorry.

--
Sandy
In Perth, the ancient capital of Scotland

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk


"Sandy Mann" <sandymann2@mailinator.com> wrote in message
news:eEBWhCKaGHA.3408@TK2MSFTNGP04.phx.gbl...
> Try:
>
> =SUMIF(H1:H12,"<"&TODAY()-60,I1:I12)
>
> Adjust to suit your own ranges.
> --
> HTH
>
> Sandy
> In Perth, the ancient capital of Scotland
>
> sandymann2@mailinator.com
> Replace@mailinator.com with @tiscali.co.uk
>
>
> "nastech" <nastech@discussions.microsoft.com> wrote in message
> news:E9E5ED82-28B4-4FFB-AD3F-6F339A641AB2@microsoft.com...
>> Hi, I am looking for way to custom format cell to read 1.511B or
>> 1.511M
>> as: 1B 1M (also would like example for 1.5B or 1.5M). thanks
>>
>> already have cell formatted as Number, works with other work column with
>> e.g.:
>> =IF(OR(CE138=0,BZ138={0,"n/a"}),"",(LEFT(BZ138,LEN(BZ138)-1)*IF(RIGHT(BZ138,1)="b",10^9,1)/CE138*$BV$4))
>>
>> Just looking for custom formatting such as: ##0.0*
>
>