Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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" wrote in message ... 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. |
#3
![]() |
|||
|
|||
![]()
Thank you - I then needed to add 100 to the year to make it 2000.
"George Nicholson" wrote: 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" wrote in message ... 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. |
#4
![]() |
|||
|
|||
![]()
ah, those darn centuries! :-)
-- George Nicholson Remove 'Junk' from return address. "Lannutslp" wrote in message ... Thank you - I then needed to add 100 to the year to make it 2000. "George Nicholson" wrote: 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" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I get the font color to change automatically depending on | Excel Discussion (Misc queries) | |||
Use DocProps in a change declaration | Excel Worksheet Functions | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
How to change the default font and size of "comments"? | Excel Discussion (Misc queries) |