Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula shows in cell instead of results (text reference)
I have a file with 1,000's of forumlas in it. One tab alone has over 3,400
formulas. There are 20 tabs that pull a job category name from the "rates" tab. For year 1, the formulas start in A9 and go to A63. I have multiple years that deal with the same job categories and the information for Years 2 - 5 starts on row 106 and continue down. If I put a formula in A106 that says + or = A9, the cell displays the forumla and not the job category name. Cell A106 is formatted as text which it should be. I have tried the edit format and change A106 to text then hit F2 then Enter. This does not fix the problem. I am using Excel 2003. What is causing the problem? Any help is appreciated. This has been a problem that has been going on for years but no one has ever taken them time to attempt to diagnose. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula shows in cell instead of results (text reference)
Entering a formula in a cell that is formated text gives you test, not a
formula. Try formating A106 as general then reenter the formula and see if that works. Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula shows up as text in cell | Excel Worksheet Functions | |||
format a cell with a formula so an empty reference cell shows blan | Excel Discussion (Misc queries) | |||
Cell only shows link in text, not contents of reference cell | New Users to Excel | |||
Some text shows in the formula bar but not in the cell. | Excel Discussion (Misc queries) | |||
TEXT SHOWS UP IN FORMULA BAR BUT NOT IN CELL? | Excel Discussion (Misc queries) |