Prev: auto update to multiple worksheets
Next: Working hours
From: RagDyeR on 5 Apr 2010 22:55
You're welcome, and we appreciate the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Dave" <Dave(a)discussions.microsoft.com> wrote in message
news:B3726494-632F-4C68-B6E0-F4D919892132(a)microsoft.com...
tompl, Paul, and Ragdyer, thanks for the help. Your input fixed a years old
problem.

"RagDyer" wrote:

> <<<"Cell A106 is formatted as text which it should be.>>>"
>
> Since A106 contains the formula:
> =A9
> it *SHOULD NOT* be formatted as text.
>
> Format A106 to either General or Number and your problem should be solved.
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "Dave" <Dave(a)discussions.microsoft.com> wrote in message
> news:6D596419-39A5-465E-BF0D-39932E300CC6(a)microsoft.com...
> >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
>
>
> .
>


First  |  Prev  | 
Pages: 1 2
Prev: auto update to multiple worksheets
Next: Working hours