The UPPER function transforms all lower-case characters in a text value to upper case. Its output is always a value of type text. If it operates on a value stored by Excel as a number, like a date, then the number underpinning that value is converted to text and becomes the UPPER function’s output.