Re: How do I change 40402 into 04/04/2002?
- From: "George Nicholson" <JunkGeorgeN@xxxxxxx>
- Date: Wed, 30 Mar 2005 15:10:35 -0600
use DATE(year,month,day)
first, make it easy on yourslef and make sure all your data is 6 characters
long, with leading zeros.
ColumnB = Text(ImportedDataColumn,"000000")
MyDate = DATE(Right(ColumnB,2), Left(ColumnB,2),Mid(ColumnB,3,2))
HTH,
--
George Nicholson
Remove 'Junk' from return address.
"Lannutslp" <Lannutslp@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:74B42F00-E95B-4247-874E-FA61F1E25605@xxxxxxxxxxxxxxxx
>I downloaded a database from an AS/400 and now I need to change numbers to
> dates. When I format it changes everything because it is reading the
> number
> as a julian date.
.
- Follow-Ups:
- Re: How do I change 40402 into 04/04/2002?
- From: Lannutslp
- Re: How do I change 40402 into 04/04/2002?
- References:
- How do I change 40402 into 04/04/2002?
- From: Lannutslp
- How do I change 40402 into 04/04/2002?
- Prev by Date: Re: Capitalizing selected area
- Next by Date: Re: Formatting dates prior to 1900
- Previous by thread: How do I change 40402 into 04/04/2002?
- Next by thread: Re: How do I change 40402 into 04/04/2002?
- Index(es):
Relevant Pages
|
