removing 'o' when referencing to a cell

J

justin vn

I have a cell (B5) that is referenced to another cell
(A1). It simply copies whatever is inputted into A1 into
B5.

How do I make it so if there is nothing inputted into A1
nothing will display in B5. Currently a zero '0' will
show in cell B5 if nothing is inputted in A1.

thanks in advance

justin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Opposite direction 9
result should equal a blank field 2
an IF function that can take no action? 4
Source and Destination worksheet difference 5
Linking text cells between 2 worksheets 0
Copy addition formula of non-consecutive horizontal cells 2
Changing cell values based on another cell 5
Naming non-contigent cells with vba 5

Top