Round to million

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
 
D

Don Guillett

one way would be to divide by a million

--
Don Guillett
SalesAid Software
[email protected]
Hi All,

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

Thanks for your help

Regards
 
G

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
 
Top