Format Functions

Case Formats

UPPER (text): Converts all characters in the text string to uppercase characters. Numeric characters in the string are not changed. For example, UPPER("EasyOffice2001") would return "EASYOFFICE2001".

LOWER (text): Converts all characters in the text string to lowercase characters. Numeric characters in the string are not changed. For example, LOWER("EasyOffice2001") would return "easyoffice2001".

PROPER (text): Returns the text string in proper-case format (i.e., the first letter of each word will be capitalized, while the remaining letters will be lowercase). For example, PROPER("my NAME is bob") would return "My Name Is Bob".

 

Number Formats

FIXED (number, precision): Rounds the number to the supplied number of decimal places (precision), formats the number in decimal format, and returns the result as text. For more details, see Fixed Decimals or Commas.

DOLLAR (number, precision): Returns the number as text, using the local currency format and the supplied number of decimal places (precision). Omitting the precision argument assumes two decimal places. EasyOffice uses the US Dollar format. For more details, see Currency.

USDOLLAR (number, precision): Returns the number as text using the US Dollar format and the supplied precision. Omitting the precision argument assumes two decimal places.

TEXT (number, format): Returns the number as text, using the specified format. The format must be enclosed in double quotes. For example, TEXT(0.58, "0.00%") would return "58.00%". For more details, see Using the TEXT Function.

 

See Also:

Overview: Number Formatting