Getting a cell to return text

[groleaujj]

I currently have a cell that is linked to another via

This cell contains

=A1 -so whatever is in a1 is duplicated in this cell

In A1 if the value is 0 i need it to show (the values are calculated weights)

However

I need the cell that has the formula =A1 to be formatted so if the cell has any value other then 0 to show that value, if it is 0 i need it to say "void" or be blank.

[Miraun]

=If(A1=0,"",A1)

[groleaujj]

sigh... thats too simple and i was close... i really need to learn sthis stuff better