Formulas act as per type of data in cells which may be
Text – It start with single inverted quote (‘) and left-aligned with alphanumeric being text entries.
Numeric – They are numbers and all data should be numbers and are right- aligned.
Formula – It start with a plus (+)or equal to (=) sign.
Date – It is right aligned, and data changes to preset date format separated by ‘/’ or ‘-‘.