$$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)