Hello,

With every worksheet that I start to create with formulas, I seem to get the
formula showing in the cell instead of the text. When I go to look at the
format it is set as text. Why wouldn't it be defaulted as General?

Here is an example: (I've only had this issue at one company, no where else.)
Cell A1: Apple
Cell B1: 24310
Cell C1: =CONCATENATE(A1,B1) This usually only shows in the formula bar and
the cell shows Apple24310, but not with these spreadsheet;, it shows
=CONCATENATE(A1,B1).

Any help would be apprecaited.

Thanks,

Stephanie

Do you have a sheet.xlt Template in your XLSTART folder which would be the base
for any new InsertWorksheet.

If so, perhaps it is formatted as text.


Gord Dibben MS Excel MVP

On Tue, 12 Dec 2006 10:57:01 -0800, steph44haf
wrote:

Hello,

With every worksheet that I start to create with formulas, I seem to get the
formula showing in the cell instead of the text. When I go to look at the
format it is set as text. Why wouldn't it be defaulted as General?

Here is an example: (I've only had this issue at one company, no where else.)
Cell A1: Apple
Cell B1: 24310
Cell C1: =CONCATENATE(A1,B1) This usually only shows in the formula bar and
the cell shows Apple24310, but not with these spreadsheet;, it shows
=CONCATENATE(A1,B1).

Any help would be apprecaited.

Thanks,

Stephanie