TYPE

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I am confused about the TYPE function. I can put things into A1 such that
=TYPE(A1) returns 1, 2, 4, 16 or 64. Can anyone give an example of something
that will return 8 ? I am using use Excel97.
 
Paul,

As far as I know, no one has been able to make the TYPE function
return a value of 8 (formula). It is a bug or design flaw. It
was "corrected" by changing the help files so that 8 is no longer
a return value.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
I have never heard of anyone actually getting 8. The type 8 is removed from
the help in
Excel 2002.. All it refers to is the numbers you are mentioning.
 
Back
Top