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