At 11:28 10/08/2008 +0200, Johnny Rosenberg wrote:
Maybe off topic, but it would be nice if it was
possible to convert numbers to numbers as well,
such as the conversion from 20080810 â 39670
(=2008-08-10 if the cell is formatted as the ISO
8601 date format). I actually have a file with
such dates. In my case I formatted the cells
like 0000"-"00"-"00 to make it look like dates,
but now, a few years later, I realize that there
are many advantages by converting them to real dates
Try:
=DATE(INT(x/10000);MOD(INT(x/100);100);MOD(x;100))
and then Paste Special back over the original
values with "Date & time" ticked and Formulas not ticked?
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
