Date Formatting
I have two cells containing dates in the format of 07/14/05. I can use
Selection.NumberFormat = "m/yy;@" to change the format of the cells to month
and year. However, Excel still uses the original serial number from
07/14/05. I am trying to compare these two cells and delete any transactions
that did not take place in the same month, but until I figure this out I can
only capture the transactions in the same day. Does anyone have any
suggestions?
|