Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Value Function
David- this didn't work. I tried it and no luck. Thanks anyway.
-Anthony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |