Zero values

[rcfb25]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) When I copy and paste a formula to a range of cells, any blank cell returns 0.00. In Windows there is the option in ''Tools" "Options" to remove any Zero Values. Is this possible with Mac?

 

[CyberTaz]

Unless there's more you aren't describing this question was answered by
Mungo's reply in this same thread... On a Mac Preferences from the
[Application Name] menu is the equivalent of Options in Windows programs.

If that doesn't provide what you need please post a NEW message rather than
a REPLY to an old one. Include exact OS X & Office update levels and a
thorough description of the situation & what you need to accomplish.

Regards |:>)
Bob Jones
[MVP] Office:Mac