I can't duplicate your problem.

Click in one of the cells that you say returns a date.
Then,
<Format <Cells <Number tab,
And what do you see selected in the "Category" window?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Terry" wrote in message
...
When I set up format I select "whole" column, unless that is wrong way, I
think I got all of them.

Excel automatically my format occur at that column.