replace zero with picture

[Ashwini]

Hi,

This is Ashwini here.

I am having some problem in excel. Can you help??

I have to replace all 0 (ZERO) with picture with the help of formula. It is
possible?

Regards,
Ashwini

 

[Spiky]

Hi,

This is Ashwini here.

I am having some problem in excel. Can you help??

I have to replace all 0 (ZERO) with picture with the help of formula. It is
possible?

Regards,
Ashwini

Do you mean replace 0 with the word "picture", or an actual picture?
An actual picture is defined as an object to Excel, and the number 0
is defined as a value (usually), I don't think you can replace a value
with an object. Maybe with macro code you could do something similar.

You can use the Find/Replace command to replace a 0 with something
else if you want permanent replacement. Or the function SUBSTITUTE can
do this in a formula so you don't change your original data.