 |
|
|
|
Next: Dunks SBs Shoes price$43(Duty-free goodsNi)
|
| Author |
Message |
External
Since: Dec 8, 2008
Posts: 1
|
(Msg. 1) Posted: Mon Jan 05, 2009 7:43 pm
Post subject: Convert odd number to date
Archived from groups: microsoft>public>excel (more info?)
|
|
|
Hello-
I have a report that I ran from our AS400, and the date fields are
coming out strange. I have a string of 109031 that I can cross
reference to see that the "09" is the year, and "031" is the day of
the year. All of the numbers in these fields start with a 1, but it
does not seem to signify anything. 108366 would mean 12/31/2008, etc.
Any ideas on a formula to get these columns to display a regular
calendar date? |
|
| Back to top |
|
 | |
External
Since: Dec 24, 2008
Posts: 3
|
(Msg. 2) Posted: Mon Jan 05, 2009 10:17 pm
Post subject: Re: Convert odd number to date
Archived from groups: per prev. post (more info?)
|
|
|
One way:
=DATE(MID(A1,2,2),1,MOD(A1,1000))
In article
wrote:
> Hello-
>
> I have a report that I ran from our AS400, and the date fields are
> coming out strange. I have a string of 109031 that I can cross
> reference to see that the "09" is the year, and "031" is the day of
> the year. All of the numbers in these fields start with a 1, but it
> does not seem to signify anything. 108366 would mean 12/31/2008, etc.
> Any ideas on a formula to get these columns to display a regular
> calendar date? |
|
| Back to top |
|
| |
External
Since: Dec 24, 2008
Posts: 3
|
(Msg. 3) Posted: Mon Jan 05, 2009 10:20 pm
Post subject: Re: Convert odd number to date
Archived from groups: per prev. post (more info?)
|
|
|
Correction:
=DATE("20"&MID(A1,2,2),1,MOD(A1,1000))
In article wrote:
> One way:
>
> =DATE(MID(A1,2,2),1,MOD(A1,1000))
>
> In article
> wrote:
>
> > Hello-
> >
> > I have a report that I ran from our AS400, and the date fields are
> > coming out strange. I have a string of 109031 that I can cross
> > reference to see that the "09" is the year, and "031" is the day of
> > the year. All of the numbers in these fields start with a 1, but it
> > does not seem to signify anything. 108366 would mean 12/31/2008, etc.
> > Any ideas on a formula to get these columns to display a regular
> > calendar date? >> Stay informed about: Convert odd number to date |
|
| Back to top |
|
| |
| Related Topics: | Formatting number in Data Table - I am using Excel 2007. I have a spreadsheet that the figures can be negative or positve. I have formatted the cells with this custom format $#,##0;[Red]$-#,##0. On the spreadsheet the format works fine. I created a chart from the data. I have a data...
using if + networkingdays end with #name and not number of.. - Hi, I'm having prob. getting the result for above function/formula. Co-worker use same function and it works for him. Running same function and file he used on my computer end with #name. Office is ok. function/formula is ok. Had same prob. 2 years ago...
Date in excel - When I start Excel I would like to set the system time automatic back. Something like this Read current date Set date to 25-12-9 start excel stop excel Set date to curret date Can anybody help with this ?
Current date in cell - How do I put a current date in cell, meaning a formula so that when I open the spreadsheet the cell will have todays date in it. 4th July 2009 thanks
show date in proper format - hi, If i enter this formula "Date: " & today() it shows Date in digit value i.e. Date: 40042. I want it to show Date: 17/08/2009 How? Mosaddeq |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
