Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,388
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 342
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula shows up as text in cell BK523 Excel Worksheet Functions 2 March 20th 09 02:00 PM
format a cell with a formula so an empty reference cell shows blan M2 Excel Discussion (Misc queries) 3 November 7th 06 11:42 PM
Cell only shows link in text, not contents of reference cell Jay Mac New Users to Excel 4 August 23rd 05 08:36 PM
Some text shows in the formula bar but not in the cell. George M. Excel Discussion (Misc queries) 5 May 20th 05 12:43 AM
TEXT SHOWS UP IN FORMULA BAR BUT NOT IN CELL? C-ROB Excel Discussion (Misc queries) 3 April 1st 05 11:15 PM


All times are GMT +1. The time now is 04:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"