Thread: Format numerical value to Million
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Format numerical value to Million
On Sun, 9 Nov 2008 18:11:59 -0800, "Shane Devenshire"
wrote:

Hi,

Actually, you can get just what you want -

#","#,,\M

Cheers,
Shane

Hmmm. When I try that on 1,234,567 I get ,1M and not 1,2M

--ron
Reply With QuoteReply With Quote