Excel 2000: Query returns date instead of number
 

I am working with a timesheet I created in Excel 2000. Cell K410 should
return a numeric answer to a query but instead answers €˜Feb 8. No other
cells produce a fallacious result like this. How do I correct this apparent
bug?
--
Kreigh

Excel 2000: Query returns date instead of number
 

You could try formatting this cell a General
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Kreigh" wrote:

I am working with a timesheet I created in Excel 2000. Cell K410 should
return a numeric answer to a query but instead answers €˜Feb 8. No other
cells produce a fallacious result like this. How do I correct this apparent
bug?
--
Kreigh