Format Numeric Field to show in Millions/Billions etc

#1

Hi , Currently numeric field shows as is which means if value is 1,000,000 then it shows as is, now i want to show like 1Million something like this. Is it possible currently in metabase ? if yes how can this be acchieved?

#2

In the number formatting, use:
image
You’d need to enter 0.000001
Then in suffix:
image
or your preferred text

#3

Perfect thanks