Re: date conversion
From: Bernie Deitrick (_at_)
Date: 09/21/04
- Next message: BenjieLop: "Re: How do I change numbers to negative without re-typing?"
- Previous message: JenS: "How do I change numbers to negative without re-typing?"
- In reply to: Duncan Ross: "date conversion"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 21 Sep 2004 11:54:54 -0400
Duncan,
You will need to download John Walkenbach's extended date function from
http://j-walk.com/ss/excel/files/xdate.htm
You may also need to extract the parts of your date strings: try Data | Text
to columns... using the / as the delimiter.
HTH,
Bernie
MS Excel MVP
"Duncan Ross" <Duncan Ross@discussions.microsoft.com> wrote in message
news:1D645615-AA4C-4F70-AA16-AC4B437D84E0@microsoft.com...
> I have a problem that may require several steps to resolve. I have a
series
> of nineteenth century dates in dd/mm/yyyy format, (e.g. 23/04/1857) that I
> want to convert to serial numbers and perform some calculations with. I
> just can't seem to resolve this.
>
> Any help greatly appreciated.
>
> Duncan
>
- Next message: BenjieLop: "Re: How do I change numbers to negative without re-typing?"
- Previous message: JenS: "How do I change numbers to negative without re-typing?"
- In reply to: Duncan Ross: "date conversion"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
