I am trying to change a cell's NumberFormat within the
WorksheetChange_Event. The format is changed, but it is
not reflected in the cell until the next time I change the
cell. Any ideas on how to make the NumberFormat be
applied and used immediately after the cells value is
changed? TIA