Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formating a date
Hello,
When I pull data the dates came over looking like this: 1090325 This represents March 25, 2009. All of the dates have the 1 in front of them. How do I eliminate the "1" and show a proper date? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formating a date
With your value in A1, in another cell use:
=DATE(MID(A1,2,2)+2000,MID(A1,4,2),RIGHT(A1,2)) -- Gary''s Student - gsnu200842 "Jim" wrote: Hello, When I pull data the dates came over looking like this: 1090325 This represents March 25, 2009. All of the dates have the 1 in front of them. How do I eliminate the "1" and show a proper date? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formating and date changes | Excel Discussion (Misc queries) | |||
Date formating | Excel Worksheet Functions | |||
Date Formating | Excel Discussion (Misc queries) | |||
Date Formating | Excel Worksheet Functions | |||
Date formating | Excel Discussion (Misc queries) |