Steve -

Get rid of the spurious characters. Use a custom number format like 0" mm" or
0.00" mm" which shows the number with the suffix but doesn't make the suffix part of
the value of the cell.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

smintey wrote:

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