<div>
Ef'ing rockstar! &nbsp;Thanks!
</div>


<div>
<div class="content wysiwyg-content">
Hey Experts. &nbsp;I have a spreadsheet that contains a lot of 0.00% because there is nothing to calculate. &nbsp;Since the 2 numbers aren't there, how can I get a - to show up until there are two numbers to divide?
</div>
</div>


Hey Experts.  I have a spreadsheet that contains a lot of 0.00% because there is nothing to calculate.  Since the 2 numbers aren't there, how can I get a - to show up until there are two numbers to divide?

Replace numerous 0.00% with -

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Windows 7 is an operating system from Microsoft. Features include multi-touch support, a redesigned Windows Shell with a new taskbar, referred to as the Superbar, a home networking system called HomeGroup, and performance improvements.

Windows 7

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.