Format Postal code : Format « Data Type Functions « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Data Type Functions
  3. Format

Format Postal code

 
Sub FormatPostalCode()
  Debug.Print Format("qqqqqqqqq", "!&&&&&-&&&&")
End Sub








Related examples in the same category

1.The Format function formats expressions in the style specified
2.Format$(Now, "Short Date")
3.Format$(Now, "DDDD")
4.Format$(Now, "DDD")
5.Format$(Now, "YYYY")
6.Format$(Now, "WW")
7.Format Phone number
8.Illustrate the Format method