Microsoft Software

Recent Answers

2012-05-24 Excel - How to display as zero dollars:

When you get to the Format Cells popup, under Category:, instead of choosing Accounting, choose Custom, then enter under Type:    _($* #,##0.00_);_($* (#,##0.00);_($* #,##0.00_);_(@_)    This Custom format

2012-05-24 Excel - Combinig Macros:

David,    You would do an Alt+F11 to get to the vba and then in the project manager, double-click the ThisWorkbook entry for your workbook (or right click on it and select view code).  In the module, paste

2012-05-24 Excel - Last date in series of patient contacts:

Helen    Here is the way I would handle it.    First---Sort the entire list, both column 1 and column 2, by unique identifier.    Second go to the subtotal feature and subtotal the list at each change

2012-05-24 Excel - How to display as zero dollars:

Assuming you're using Excel 2007 or later:    To display zero as $0.00, select cells to format and right-click, choose Format Cells, Number, Category: Currency, OK.    To display zero as $ -, select cells

2012-05-24 Excel - Data update in other file:

1) The data exists on sheet1 of the workbook that has this macro in it?  2) The macro must copy M3:M16 of this workbook's sheet1?  3) The macro must take the value in Q7 of sheet2 to open a second workbook