On Fri, 15 May 2009 00:29:44 GMT, "AHizon via OfficeKB.com" <u38169@uwe wrote:

Should I send you the actual file to make it easier to understand? Because
even with me opening the actual file that it's referencing to obtain the
Eligibility Date, it still gives me the #VALUE error.

The opening of the actual file was to avoid getting the #REF! error when you
did the F9 bit. And that seems to have worked. Now you are getting what looks
like dates rather than #REF errors.


When I do the F9 on the cells that give me the #VALUE, below are some of the
results:
05/09/2008
04/12/2008
08/11/2010
03/08/2007
01/21/2008
06/23/2008
02/22/2009
04/09/2009
01/18/2009
07/17/2008
06/18/2009
06/28/2009
06/28/2009
06/23/2010
08/24/2010
07/19/2008
09/05/2008
08/01/2008

Now what about the results of that formula that I posted to see what values
come out.

You know, the

=CODE(MID($Q$5,ROWS($1:1),1))

where Q5 is one of the cells above.

Enter that formula in some cell, then fill (copy/drag) down and report the
results down to the #VALUE! error.

You might see something like:

51
57
53
55
55
#VALUE!
#VALUE!

or you might see something like

53
47
57
47
50
48
48
56
#VALUE!
#VALUE!

or maybe even something like:

53
47
57
47
50
48
48
56
160
#VALUE!




It might be easier if you see the actual file I'm trying to work on...Is
there a way to attach the file in this blog?

This is not a blog. Rather it is a newsgroup hosted on Microsoft servers.

People access this newsgroup in a variety of ways. How to attach a file will
depend on how you are accessing it, and that is something you'd have to figure
out. I can't help you there.

But most people are hesitant to download files from NG's because of all the
abuse that is going on in the Internet.

And you'd have to post not only the file giving the errors, but also the
precedent files; and since your formulas won't refer to the same data source,
you'd have to change them so they do, and it would be a real pain. In other
words, I don't have an M: drive on my system, for one thing.

Better to go through the steps and try to understand what's going on, I think.
--ron