Number Format Question

  • Thread starter Thread starter John
  • Start date Start date
J

John

If I have a large number, such as 140,937,960, and I want to express
this number as 140.938M, is there a way that Excel can make this
conversion automatically via a formula or format?

Thanks,

John
 
Custom format:
0.000,,"M"
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

If I have a large number, such as 140,937,960, and I want to express
this number as 140.938M, is there a way that Excel can make this
conversion automatically via a formula or format?

Thanks,

John
 
Back
Top