Format Function -- User-Defined String Formats

Description

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.


See Also

Format Function — Different Formats for Different String Values, Format Function — User-Defined Date/Time Formats, Format Function — User-Defined Numeric Formats.