Value not Showing

C

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!
 
C

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!
Click to expand...

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

=Concatenate(blah blah blah)
 
Top