You might want to always use exactly the same number of characters. If expression is 0 or less, TEXT reverts to the normal behavior. If the expression evaluates to something other than 0, then leading zeros are used. If expression is 0, then leading spaces are used. Sometimes you want to compute one value if a certain condition holds and another value when it doesn't.
Expression is an expression.
Using the current value of the clock You can use the current value of the Macintosh's clock in your formulas. Any other value for expression gives -1. You can compare text values to each other or see if one value contains another value. Checking the system environment The MacOS supplies a function, Gestalt, that programs can call to query the system about what resources, options, features, and product versions are available. Updated by Dale Talcott of Purdue.