Thread: Format a number as ppm
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hmm hmm is offline
external usenet poster
  
Posts: 175
Default Format a number as ppm
I have numbers I would like expressed as parts per million (ppm). Just as %
format displays the number multiplied by 100, ppm format should display the
number multiplied by 1 million (and append the unit "ppm"). Is there a way I
can enter this as a custom format, including in charts?
Reply With QuoteReply With Quote