[>=1000000]$#.0,,"M";[>=1000]$#,##0,"k";0 Enter the above as Custom Cell Formatting to get pretty output (BOE style) such as "$1.9M" or "$38k" instead of big integers.