.NumberFormat not getting applied?
---------------------------------------------------------------------------------
Const mFormat_DollarAmount As String = "#,##0.00"
4140 With .Columns(mColNum_FP_AmountOutstanding)
4141 .ColumnWidth = 15
4142 .NumberFormat = mFormat_DollarAmount
4143 .HorizontalAlignment = xlRight
4149 End With
---------------------------------------------------------------------------------
The width and horizontal alignments are working, but
the .NumberFormat is not.
Same problem with date columns:
---------------------------------------------
Const mFormat_Date="mm/dd/yyyy"
..NumberFormat = mFormat_Date
--------------------------------------------
Some limitation on what I can do at the column level?
|