Text value 0e00 still treated as a number?

F

Frag

I have two sets of numbers in hex and am comparing one set against the other.
It appears that 0E00 when entered as a text formatted cell is treated as
numeric 0 when consequently referenced for formatting operations.

(The problem actually happens with certain ranges 0E00->0E09 but not 0E0A ->
0E0F, and then again with 0E10->0E19 but not 0E1A->0E1F etc)

I have tried setting the format of cells used for the ranges to text before
entering the values and using the apostrophe before each value, and
combinations of both techniques - I still get the same issue.

I can supply an example if required. Any ideas?

Thanks
 
D

David Biddulph

When I format a cell as text and type in 0E00, it stays as a text string.
What exactly are you doing? How are you putting the data into the cells?
What operation are you carrying out on the data?
 
D

Dave Peterson

When you work with =countif() or =sumif(), you'll notice that you can use
strings in that criteria argument.

=countif(a1:a20,">"&0)
to count the number of cells in A1:A20 that are greater than 0.

I think that excel is seeing your text as numbers--some in scientific notation

If you want to distinguish between a number 0 and text '0 (apostrophe for
emphasis only), you can use a different function:

=SUMPRODUCT(--($A$1:$A$20=B1))>0
 
D

Dave Peterson

I'd be very surprised if you see a response from MS. Every so often, an MS
employee will post a response to a question--but they're few and far between.

For the overwhelming most part, this is a peer to peer newsgroup--just regular
people trying to help regular people <bg>.
 
Top