Value Function
 

I have a weird problem. When I bring data in from my AS/400 system
they come in like this: 440914- which is the date 9/14/1944. I used
the value formula to switch around the digits and add the slashes, but
I have ran into a problem.

This value: 250211- is being read as 2/11/2025- when it should be
2/11/1925.

This doesn't happen to all of them. Can someone please help me?

-Anthony Morano
Pension Intern.

Value Function
 

Windows Regional Options/ Customize/ Date ...
will give you the range of dates to assume for 2-digit years.
--
David Biddulph

wrote in message
...
I have a weird problem. When I bring data in from my AS/400 system
they come in like this: 440914- which is the date 9/14/1944. I used
the value formula to switch around the digits and add the slashes, but
I have ran into a problem.

This value: 250211- is being read as 2/11/2025- when it should be
2/11/1925.

This doesn't happen to all of them. Can someone please help me?

-Anthony Morano
Pension Intern.

Value Function
 

Use the DATE() function to force selection to the correct century. With:
250211-
in A1, for formula:
=DATE(1900+LEFT(A1,2),MID(A1,3,2),MID(A1,5,2))
will return
2/11/1925
--
Gary''s Student - gsnu2007h


" wrote:

I have a weird problem. When I bring data in from my AS/400 system
they come in like this: 440914- which is the date 9/14/1944. I used
the value formula to switch around the digits and add the slashes, but
I have ran into a problem.

This value: 250211- is being read as 2/11/2025- when it should be
2/11/1925.

This doesn't happen to all of them. Can someone please help me?

-Anthony Morano
Pension Intern.

Value Function
 

David- this didn't work. I tried it and no luck. Thanks anyway.

-Anthony