Round to million

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

How do I round numbers to millions e.g. £2,500,000 would
show £2.5m

Thanks for your help

Regards
 
one way would be to divide by a million

--
Don Guillett
SalesAid Software
(e-mail address removed)
Hi All,

How do I round numbers to millions e.g. £2,500,000 would
show £2.5m

Thanks for your help

Regards
 
With Arial as font......

Custom Format as ALT + 0163#.0,,"m"

ALT + 0163 on the NumPad, then type in the rest.

Gord Dibben Excel MVP
 
Back
Top