I have the need to display currency left justified and trimmed of blank spaces with two decimals and thousands seperator.

If I use the format @B$ by selecting the Currency and the Left Justify option I get the following:
$123456.1234

If I change it to $999,999.99 I get the following
$ 456.66
$123,123.55

I need

$1.55
$123.45
$123,345.99

What am I missing?

TIA