View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Orchid Orchid is offline
external usenet poster
 
Posts: 2
Default Format numerical value to Million

Hi,
I try to format a numerical value in Million. But I don't want to use
the number to divide by 1,000,000. Is there any way which I can just
use a format function? (i.e.: 12,666,678 ---- 12,7)
Your help is greatly appreciated! Thanks in advance!