Excel Data Label custom formate

Data label -> Custom -> Add Format
#,##0.0, K
Applying #,##0,“k” to 1000000 –> 1,000,000k –> 1,000k
Applying #,##0,,“M” to 1000000 –> 1,000,000M –> 1M