Trying to get a column to auto-format numbers based on value - I've
done some Google searching, checked through newsgroup archives and
must be looking in the wrong place.

I have a variety of numbers from $146.0B to $.0093B using a Custom
Format of $#.0####,,,"B". Ideally, the "$.0093B" should be rendering
as $9.3M but I'm not sure how to do an if/then statement or some sort
of tweak to allow this to happen.

Is this even possible or should I do everything in millions?