View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default round numbers in the millions to numbers in the thousands

Use a custom format of #,##0,;-#,##0,

--
__________________________________
HTH

Bob

"Little Red" <Little wrote in message
...
We are trying to display numbers in the millions into numbers in the
thousands, i.e. 20,000,000 to 20,000