Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
.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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
.numberformat Q | Excel Worksheet Functions | |||
Numberformat applied but does not change data | Excel Programming | |||
numberformat? | Excel Discussion (Misc queries) | |||
NumberFormat? | Excel Worksheet Functions | |||
Numberformat | Excel Programming |