zeros on linked sheets in 2007
 

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
©¿©¬

zeros on linked sheets in 2007
 

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
©¿©¬

zeros on linked sheets in 2007
 

On Sat, 11 Oct 2008 12:59:06 -0300, "Bernard Liengme"
wrote:

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

Thank you Bernard
I would never have found that
easy when one knows how
--
Regards
Martin
©¿©¬