Value not Showing

[clouvi]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I'm using the CONCATENATE feature. However, it will only show the formula and not the value in the cell. The formula builder shows that I'm entering the formula correctly. I checked my prefs to make sure that I don't have only formulas showing. I also tried it in the WIN version of Excel, and it works fine there.

What suggestions do you have? Thanks!

 

[Carl Witthoft]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I'm using the CONCATENATE feature. However, it will only show the formula and
not the value in the cell. The formula builder shows that I'm entering the
formula correctly. I checked my prefs to make sure that I don't have only
formulas showing. I also tried it in the WIN version of Excel, and it works
fine there.

What suggestions do you have? Thanks!

Just to be sure -- you did start out with an "=" sign? I.e. the cell
formula is

=Concatenate(blah blah blah)

 

[clouvi]

The problem was that the format of the cell needed to set to "General."

Thanks