Linking between 2 worksheets
On Apr 29, 8:49*am, Carla wrote:
I have a master price list that is linked to another worksheet in the same
file. *I have a column for the date that I update the pricing, although some
cells don't have anything filled in. *When I copy from a cell that has
nothing in it and paste the link in another worksheet, it shows as a "0". *Is
there any way to fix this?
Use if instead of formula you are currently using. IF(X = 0 ,Then "",
Else X)
Jay
|