Linking between 2 worksheets

[Carla]

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?

 

[jlclyde]

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

 

[Jim Cone]

Or you could use a custom number format similar to...

#,##0;[Red](#,##0);"";@
-or-
#,##0;(#,##0);;@

The above are in four sections separated by semi-colons.
The sections in order apply to: positives, negatives, zero, text.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Carla"
wrote in message
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?

 

[Dave Peterson]

=if(master!a1="","",master!a1)

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?