View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mumpa Mumpa is offline
external usenet poster
 
Posts: 3
Default Express a large number in fewer digits $1,264,567.50 = $1.3 M

Do you know how to automatically change a large number in fewer digits?

Express a large number in fewer digits $1,264,567.50 = $1.3 M
Like as $1.265 or $1.3 M