$$Excel-Macros$$ Re: Creating macro for formatting all cells to accounting format

ction.NumberFormat = "_(* #,##0.00_);_(* (#,##0.00);_(* ""-""??_);_(@_)" End Sub I have shorted the code to: cells.Selection.NumberFormat = "_(* #,##0.00_);_(* (#,##0.00);_(* ""-""??_);_(@_)" The workbook is hereby attached. Thanks, Kof.

$$Excel-Macros$$ Creating macro for formatting all cells to accounting format

Hi, I would like to create a macro that will format all cells in a worksheet to accounting format: _(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_) except cells conatinig dates. Thanks, Kof. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW)

$$Excel-Macros$$ How to compare rows in table

Given a Table: 100 Rows , in each row 10 cells, in each cell integer 1 digit (0 - 9) Need to compare each row to the other rows, giving mark (0-10) to the row equal the maximum cells found overlapping with one of the row in the table. Thanks. -- --