Round to million

[Guest]

Hi All,

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

Thanks for your help

Regards

 

[Don Guillett]

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

 

[Gord Dibben]

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