Setting Custom Format for numbers to show prefix and decimal

[Rainbow_P]

Good day!


[>999999] #,,"M";#,"K"

Format Cells > Number > Custom

Above is the line that I am using for custom format. For example, with the cell value 1234567, when the format applied, it will show 1M.

I want add a prefix dollar sign to it ($), and let it display 1 digit after decimal.

By trying differently, like $ [>999999] #.0,,"M";#,"K" etc, I still don't get it working.

What's the correct way to set it? Thank you.

 

[RoryA]

It would be:

[>999999]$ #.0,,"M";$#.0,"K"

I assumed you wanted a decimal place for the K option too?

 

[Rainbow_P]

It would be:

[>999999]$ #.0,,"M";$#.0,"K"

I assumed you wanted a decimal place for the K option too?

@RoryA, thank you for the guidance!