Rick, the sql data which gets extracted appears in certain cells, and
I'd like to leave those cells as the data display sensitive cells,
without adding another row or column to extract the date-text-date
format.

I have a possible idea for a macro function which could toggle the display
back and forth between you number format and the month-year format, but I
would need to know what those "certain cells" are. Are they fixed in
number (count)? How many of them are there? Are the contiguous?

I should point out that the above idea will not be a viable one if you have
calculations or dependencies on those cells containing your 1xxxx number. On
the other hand, if those cells are for display only, and you have no need to
retain the 1xxxx format, we could probably make the conversion automatic
(that is, without the need for a toggle). Let me know if either of these
conditions apply.

Rick