Is there a wildcard character that I could use in this format or has anyone created a format that would meet my needs? If I can pull this off, it could mean a promotion. Question: Is there a way to hide zero valued lines within a pivot table in Microsoft Excel 2011 for Mac? I have a table with two columns Order ID and Total (Sum of Quantity) and I would like to hide the Orders with no quantity total against them - is this possible? Acrobat reader for mac os. To add a combo box in Excel 2010 and Excel 2007, click the Developer tab, click Insert, and then click Combo Box under Form Controls. The INDEX formula in cell A1 uses this number to display the item's name. I've modified the 'hh:mm:ss' template to accomodate the format I need, but it will not recognize letters for the obvious reason. The characters can be either letters or numbers.
I'm trying to create an Excel sheet to display MAC addresses in the following format - 00:00:00:00:00:00 However.