Office button | Excel Options | Advanced tab in left panel
Locate 6th item down: Display Options for This Worksheet
Uncheck: "Show a zero in a cell that has zero values"
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

<Martin ©¿©¬ @nohere.net wrote in message
...
Hi
using office 2007
When I paste a row link from another sheet it puts "0" in all the
empty cells is there a way to stop this
In 2003 it was Tools Options Zero Values, but I can't find the tools
menu in 2007
--
Martin
©¿©¬