You can use any of the following characters to create a format expression for strings:
Character |
Description |
@ |
Character placeholder |
Display a character or a space. If the string has a character in the position where the @ appears in the format string, display it; otherwise, display a space in that position. Placeholders are filled from right to left unless there is an ! character in the format string. See below. | |
& |
Character placeholder |
Display a character or nothing. If the string has a character in the position where the & appears, display it; otherwise, display nothing. Placeholders are filled from right to left unless there is an ! character in the format string. See below. | |
< |
Force lowercase |
Display all characters in lowercase format. |
Character |
Description |
> |
Force uppercase |
Display all characters in uppercase format. | |
! |
Force left to right fill of placeholders |
The default is to fill from right to left. |
Format Function — Different Formats for Different String Values, Format Function — User-Defined Date/Time Formats, Format Function — User-Defined Numeric Formats.