Number format as millions

[NJS1982]

Hi, does anyone know how to display numbers as "£0.55m"?
I have the code type for displaying anything OVER £1million
£#.##,,"m"
...but whenever a figure is below £1m, it shows as £.55m and I want it to show as "£0.55m"
Thanks!

 

[Fluff]

Replace the first # with a 0

 

[Special-K99]

I was too late!

Use
£0.##,,"m"

 

[KirnonBhale]

If you use £0.00 I think £0.0#,,"m" looks pretty nice.

Replacing just the first # with 0 will always leave a trailing "." after a round 1million. Which is why I replace the 2nd hash as well.

 

[NJS1982]

Perfect, thanks!!

 

[Fluff]

Glad we could help & thanks for the feedback