I am trying to format a number 15,000,000 to 15M. This issue I am having is that when I try to create a column that does this 15,569,245/1,000,000 the result is 15.569245 which I then want to format as just $15.6 M. I am doing this in two steps currently.
Col A 15569245/1000000 , then set the column formatting to numbers with 1 decimal.
Then in another column i concatenate ("$", ColA, “M”)
Is there a better way?