Solved: Changing Date Format in an Array

[mferrisi]

I created an array that pushes back dates from an excel worksheet. They come into the Array in "mmm-yy", I would like to change them to "YYYY" format.

For efgh = 2 To abcd
Arr(efgh) = Range(Cells(efgh, 5), Cells(efgh, 5)).Value

????????????

Next efgh

[Bob Phillips]

Just format the results cells to YYYY

[mferrisi]

Is there a way to do it inside the array? I would rather not change the cells, since I would have to change them back again....

Thanks

[Bob Phillips]

You would have to load them formatted one by one.

[mferrisi]

That's fine. So long as the cells are not altered. What woudl that look like?

Thanks,

Matt

[Bob Phillips]

For efgh = 2 To abcd
Arr(efgh) = Format(Cells(efgh, 5).Value,"yyyy")
Next efgh