Replacing zero's

[ingram010]

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

 

[VoG]

Replace 0 with =NA() and tick entire cells only.

 

[Geoff H]

Hi,

try : Tools / Options / View, ... & de-select zero values