0

I understand in Microsoft Excel you would use the format string $#.##,," M"

so that

12,271,359 would appear as 12.27M

I am alittle confused with the Numbers app on Mac (the excel equivalent) and I do not have Excel on Mac.

Thanks!

1

In Custom Format, Number…

Keep the default [#,###] it will auto-add
Drag in a decimal [.##]
Drag in a Scale [K] & use the drop menu to change to millions

enter image description here

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .