It would help us if you told us what you are ultimately trying to do. I
doubt that changing your data from dates to text is necessary.

Rick


"Fiona" wrote in message
...
I want to use Datevalue. To use this, the date must be formatted as text.
The
only way I can get Datevalue to work is to insert an apostrophe (') before
the date, manually. There must be an easier way? (I have 30,000 lines of
data
to format).
Any ideas?

Thanks,

Fiona