I have a dilemna in trying to chart some data. Wondered if anyone has run
across this before.

Have data with a space instead of a comma, IE 1 555.55

I was able to add the comma by using a CLEAN and SUBSTITUTE statement in a
different column, number now displays correctly IE 1,555.55

Cannot graph, and assume that is because the cell is actually a formula
rather than a number.

So I tried using a cell reference IE "=B22" in another column, and graphing
off of that column, but still displays the same "0".

Formatting the column to a number format does not seem to help.


Appreciate any help you can offer and thanks in advance.

.................Ray

If the cell contains "IE 1,555.55", Excel plots it as zero, because it is
text, not a number. You need to adjust your formula to get a numeric result.

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


"Ray & Shelley Dueck" wrote in message
news:luaIj.14593$Cj7.739@pd7urf2no...
I have a dilemna in trying to chart some data. Wondered if anyone has run
across this before.

Have data with a space instead of a comma, IE 1 555.55

I was able to add the comma by using a CLEAN and SUBSTITUTE statement in a
different column, number now displays correctly IE 1,555.55

Cannot graph, and assume that is because the cell is actually a formula
rather than a number.

So I tried using a cell reference IE "=B22" in another column, and
graphing off of that column, but still displays the same "0".

Formatting the column to a number format does not seem to help.


Appreciate any help you can offer and thanks in advance.

................Ray