Custom Formatting numbers question

  • Thread starter Thread starter Junkyard Engineer
  • Start date Start date
J

Junkyard Engineer

I have a spreadsheet with lot of millions numbers floating around. When I
make graphs out of it, there's too much zeros.

I don't want to divide all the numbers per 1 million.

Is there a way to custom format those numbers with a mask that would take
care of that problem for me ?

i.e. 7 456 890.98$ would be represented with 7,457 M$

tia
 
Back
Top