"German Velasquez" wrote:

hello,
I have a data base with no date format, just a series of numbers like
20041128 for November 28th year 2004. How can I give this information
a date format?
There may be a cleaner hack than this. But it will work.

=DATE(LEFT(cell_reference,4),MID(cell_reference,5, 2),RIGHT(cell_reference,2))