2008/8/10 Brian Barker <[EMAIL PROTECTED]> > 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.
Well, I know how to convert them, I just thought it would be a nice addition to the TextToNumbers extension, but thanks anyway for reminding me of the MOD function. I guess I would have done it without it, which would have lead to a way longer expression… J.R. > > > Brian Barker > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
