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.