functions are not displaying the results

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)

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

<[email protected]> wrote in message
news:[email protected]...
> 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)
>