Need $ Sign Visible In Custom Number Format

[Aimee S.]

[<=1000000]#0.00,," K";[>=1000000]#0.00,," M";0.0

Hi Folks.

What would I do to make this custom format display a $ sign followed by one space prior to the number?

So instead, for example, of 5.21 M it would show $ 5.21 M.

Thanks in advance for your time!!
Best,
Aimee in Madison

 

[ISY]

Hi

[<=1000000]#0.00,," K";[>=1000000]$ #0.00,," M";0.0

 

[Aimee S.]

I actually got the answer using [>=1000000] $#.00,," M";[>=1] $#.00," K";"" from a co-worker. Thanks very much for your reply! My syntax was off.