Custom Format Cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
Woops! Replied to the wrong post - sorry.

--
Sandy
In Perth, the ancient capital of Scotland

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom Format Cell 13
isayisay "CUSTOM" Formatting 2
Custom Formatting 2
Need Custom format, not a formula 21
can not find align decimal points option 4
Custom Format syntax Q 4
Custom Format with multiple conditonals 1
Custom format applicable to negative and positive numbers? 5

Back
Top