Format million

[Zan]

Does anybody know how to get Excel to format in the
millions. So that 4180000 = 4.18m.

Many thanks

 

[BrianB]

Format Cell/Number/Custom - copy/paste this :-


Code

 

[Frank Kabel]

Hi
try the custom format
0.0,,"m"