There are two approaches that may help:

1. Use the Import Wizard:
Data Inport External Data Import Data...
and tell the Wizard that the field is a Date

2. Use a small macro to "click-activate" all the cells at once. Select the
cells and run:

Sub wake_up()
Set saveit = Selection
For Each r In saveit
r.Select
Application.SendKeys "{F2}"
Application.SendKeys "{ENTER}"
DoEvents
Next
End Sub




--
Gary''s Student - gsnu2007e


"george" wrote:

The problem is next I'm imoprting data from a database and this imported
data consists os from a date_time and value. the problem is next, the time
and date field isn't recognized as such and bacause of this my query to
select a specific date range doesn't work ,however when i click on the field
then it's recognized as a date and time field. I realy can't click on every
field to recognize it.
Does anyone know how to help me.
Thx