View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cjbarnwell cjbarnwell is offline
external usenet poster
 
Posts: 1
Default Formatting Code for SI Units in Excel

The x axis of my chart is frequency in hertz. So I want the numbers to read
1 10 100 1k 100k 1M

instead of

1 10 100 1,000 100,000, 1,000,000

There is no setting for SI units in the "Format Axis" ,"Number", "Category"
, so I assume there is a custom format code. Does anyone know how to do this?