Thread: How do I change a file displayed in thousands to millions?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
  
Posts: 1,998
Default How do I change a file displayed in thousands to millions?
Right-click FormatCells NumberTab NumberSelection 0 DecimalPlaces
check the "Use thousands separator" box

Vaya con Dios,
Chuck, CABGx3



"DW" wrote:

I have a large data set that is currently displayed in thousands (ex.
2115.005), how do I change to display in millions (ex. 2,115,005)?
Reply With QuoteReply With Quote