Perhaps the cell is formatted as text, if so, change the format to General.
Or you may have formula view, OptionsToolsView and check the Formulas
checkbox.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

wrote in message
ups.com...
For some reason, my functions are not displaying their results in the
cells. All that shows up is the function itself.

What am I missing? Here's a simple example of a concatenate function to
combine two columns that contain the city and the state into one
column.

This is also what is displaying in the cell - what should have
displayed was Peoria, IL

=CONCATENATE(G3,", ",H3)