=DATE(LEFT(V9,4),MID(V9,5,2),RIGHT(V9,2)) - resets to 1900

[calciumkid]

Hi


I have this formula =DATE(LEFT(V9,4),MID(V9,5,2),RIGHT(V9,2)) - resets to 1900 which correctly transforms a date in the format 20040224 to 24/02/2004


But when the file is saved and it is opened on another computer, the formula is replaced with sometimes random values, and sometimes correct days and months but with the yearmbeing 1900

I have copy and pasted values over the correct format of the dates but this issue still seems to be happening, how can I solve this ?

[shg]

Is there a formula in V9, and if so, what?

How about instead

=--TEXT(V9, "0000-00-00")

[calciumkid]

there is just a number e.g. 20040224 representing the date, i will try your option now