If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Default seems to be set as text???
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 |
#2
|
|||
|
|||
Default seems to be set as text???
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 |
Thread Tools | |
Display Modes | |
|
|