A format expression for strings can have one section, or two sections separated by a semicolon.
|
If you use |
The result is |
|
One section only |
The format applies to all string data. |
|
Two sections |
The first section applies to string data, the second to Null values and zero-length strings. |
Format Function, Format Function — Different Formats for Different Numeric Values.