Literal Characters
In any format specification, you can include literal characters. They will be output “as is” when formatting a value.
Symbols
A literal character is specified by one of the following methods:
\c Prefix the character with a back slash.“abc” Enclose a string of characters in double quotes.Any character that is not a special symbol or cannot be part of one, is considered as being a literal character.Examples
Value | Format | Result |
|---|---|---|
1234.5 | #,##0.0# Frs | 1 234.5 Frs |
1234.5 | #,##0.0# “Frs” | 1 234.5 Frs |
1234.5 | #,##0.0# \F\r\s | 1 234.5 Frs |
12 jul 96 | “Quarter” q | Quarter 3 |
forms | RW >@< | RW Forms |
Published date: 05/24/2022
Last modified date: 02/24/2022
