Hi all
I have a load of data which I want to put in a chart, unfortunately there are a lot of 0's in this data where in fact there should be a blank cell. I have tried using the replace function but that removes all 0's, even if they are part of a usable number. For example 460 becomes 46.
Can anyone help me resolve this problem?
Many thanks
John
I have a load of data which I want to put in a chart, unfortunately there are a lot of 0's in this data where in fact there should be a blank cell. I have tried using the replace function but that removes all 0's, even if they are part of a usable number. For example 460 becomes 46.
Can anyone help me resolve this problem?
Many thanks
John