Custom Number Problem re £3.45M

  • Thread starter Thread starter Happy_Spice
  • Start date Start date
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
 
This is as close as I can get under Custom Format

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


Gord Dibben MS Excel MVP
 
Forgot the £

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

Use the numpad for entering the Alt + 0163


Gord
 
Back
Top