Custom Number Problem re £3.45M

H

Happy_Spice

Hello. I want to 3,456,322 to be displayed as an approximate i.e.
£3.45M. I am completely flumoxed by this. Help would be much
appreciated.
Regards
Happy
 
G

Gord Dibben

This is as close as I can get under Custom Format

#.##,,"M" returns 3.46M


Gord Dibben MS Excel MVP
 
G

Gord Dibben

Forgot the £

Custom Alt + 0163#.##,,"M"

Use the numpad for entering the Alt + 0163


Gord
 
Top