Thread: Convert 1.1B to 1,100,000.00
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
stevem stevem is offline
external usenet poster
  
Posts: 29
Default Convert 1.1B to 1,100,000.00
How do I format cell to convert 1.1B to 1,100,000.00 I have large list with
revenue shown in #.##B and #.##M. Need to convert Billion and Million to
standard numbers.
Reply With QuoteReply With Quote