Hello,

To get some formulas to work I have to make sure date columns have been formatted as such using "text to columns" in the data menu. It seems as though I am having to do this every time I entre a new date into the database is that right? Do you have to select text to columns every time you add some data?

I am trying to make a database that will be added to be people without good IT skills and I don't know whether they will find making the selection after they have entered any data a bit confusing.

Thanks,

anna