Formulas displaying in cell not results

[Jenn]

Hi,

I created a formula in my spreadsheet to concatenate a
few columns of data (see below) but my spreadsheet will
only display the formula in the cell and not the
results. I might have formated the column as text but
even if I change the formating or copy the formula to
another cell that's not text I can't seem to get the
result I want. I can't figure out why not?

Any help would be much appreciated.

=CONCATENATE(B2,D2,F2,H2)

 

[Frank Kabel]

Hi
if you have checked the cell formats also make sure that you uncheck
'formulas' in the menu 'tools - options - View'

 

[Jenn]

Hi Frank,

Thanks a lot!! I should have known to check that since
I've been using Excel for years but just switched to 2003
and haven't checked all the setup yet.

Have a good day,
Jenn