Not clear what you get or what you want

Do you want to see 1,500,000 as 1.5M, 1,000,000,000 as 1B etc

or

1.551M as 1,551,000, etc.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"nastech" wrote in message
...
Hi, tyrying to format cells so combinations of following look like:
1M 15B (possibly 1.5M) thanks.

samples how received:

1.551M
.071B