Formulas never show result???
Hello,
With every worksheet that I start to create with formulas, I seem to get the formula showing in the cell instead of the result. When I go to look at the format it is set as text. Why wouldn't it be defaulted as General? i know how to fix it when it happens, but I don't understand why it happens with every worksheet I create. 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 |
Formulas never show result???
See:
http://groups.google.com/group/micro...a140530cf298a7 -- Gary's Student "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 result. When I go to look at the format it is set as text. Why wouldn't it be defaulted as General? i know how to fix it when it happens, but I don't understand why it happens with every worksheet I create. 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 |
All times are GMT +1. The time now is 08:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com