Domenic,

I found out, just before your advice, that indeed the data was text. I
swithed off the announcements in Excel, therefore I did not notice. The
data is exported from a database, therefore it was apparently tekst from
a certain point. I discovered it when I used F enter in each cell.
Ctrl+C alt+es (paste special) of values would work indeed.

Thanks! I credit you for solving this!



Domenic Wrote:
Maybe the numbers are being recognized as text values by Excel. Try
the
following...

1) Select an empty cell

2) Edit Copy

3) Select your range of cells

4) Edit Paste Special Add Ok

Does this help?

In article
,
broer konijn
wrote:

Can anyone telle me when #N/A occurs as the answer to an worksheet
function?

If I try to find the mode of the list of codes below, I get #N/A

7372
7379
7379
7379
7372
7375

Does this have anything to do with the first two digits being equal?
How do I workaround? I am trying to find the most frequent ocurring
code in the list. By the way, how does the mode work if out of 4
values, both pairs of two are equal?

Thanx!


--
broer konijn
------------------------------------------------------------------------
broer konijn's Profile: http://www.excelforum.com/member.php...o&userid=34402
View this thread: http://www.excelforum.com/showthread...hreadid=552394