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.