I'd create another column for the values with MM in them. I'm assuming
that mm is at the end of each with this example.

=MID(A1,1,LEN(A1)-2)

This will have an error if the length is 2 or less or MM is not the last two
characters.

"smintey" wrote in message
...
I have a table of data in which every cell has the suffix "mm" in it. How
can
I create a chart with this data and get excel to ignore the letters. I
thought it would do it automatically but it doesnt seem to work.

Any ideas gratefully recieved!!!

Thanks in advance

Steve