Sample Custom Number Formats
Format Code Description Data with General Format Data with Custom Number Format
       
[>9999999](000)000-0000;000-0000 Displays a telephone number with or without an 7045556325 (704)555-6325
  area code. 9106325689 (910)632-5689
  If the number is greater than 9,999,999, this code 8896523 889-6523
  displays the number with an area code 5362563 536-2563
  ((000)000-0000); otherwise the number appears 2065896325 (206)589-6325
  without the area code (000-0000). 3369856 336-9856
       
[<1].00¢;$0.00_¢ Shows currency values in dollars or cents. 1.25 $1.25
  This code displays values less than 1 in 3 $3.00
  cents notation (.00¢), and display values 0.35 .35¢
  greater than or equal to 1 in dollars, and 0.95 .95¢
  leaves a space on the right so that the 22.36 $22.36
  decimals line up ($0.00_¢). 0.75 .75¢
       
[<=2]"Low"* 0;[>=4]"High"* 0;"Average"* 0 Using "If, ElseIf, Else" in a number format: 1 Low                1
          If the value is <=2, display the word "low" 2 Low                2
                  with the value, 3 Average          3
          Else If the value is >=4, display the word 4 High               4
                  "high" with the value, 5 High               5
          Else display the word "Average" with    
                  value.    
       
[Red][<=2]0;[Green][>=4]0;[Black]0 Using "If, ElseIf, Else" in a number format: 1 1
          If the value is <=2, display the value 2 2
                  with red text, 3 3
          Else If the value is >=4, display the value 4 4
                  with green text, 5 5
          Else display the value with black text.