Re: convert numbers to dates

From: Dave Peterson (ec35720_at_msn.com)
Date: 10/02/04 

Date: Sat, 02 Oct 2004 16:25:33 -0500

Glad it worked.

No_One wrote:
>
> Yes it was a $Value?
> I also when trying different things like "format, cells, number, date"
> had the ########## and tried widening the colum made no difference
> I did find a neat little trick when i started to do it manually
> Changed the cell into the date dmy
> Aimed the cursor right hand bottom corner till it went + drag down with
> right mouse button depressed
> let go the button at the end
> another box popped up
> went series = 7
> then chaged the date format to mdy
> That did the trick
> But thanks for your help, it was really appreictive
>
> PS (I did have a few gaps which i had to go back and repeated that proccess
> but i was managing to get about 8 months done at a time.)
>
> "Dave Peterson" <ec35720@msn.com> wrote in message
> news:415DB675.4542DA01@msn.com...
> > Are you sure it's #value?
> >
> > 'Cause if it were ########, maybe all you have (or had) to do is widen the
> > column??
> >
> >
> >
> > No_One wrote:
> >>
> >> Thanks for your reply Dave but unfortunatly that didn't work I end up
> >> with
> >> a #Value in the cells.
> >> I guess I'll just have to do it by hand
> >> Cheers and thanks again
> >>
> >> "Dave Peterson" <ec35720@msn.com> wrote in message
> >> news:415C5A1E.30130099@msn.com...
> >> > Try selecting your range and doing:
> >> > Data|Text to columns
> >> > specify ymd as the format for that field
> >> > And then format that column the way you want. (mm/dd/yyyy or whatever)
> >> >
> >> > No_One wrote:
> >> >>
> >> >> I'm having a simular problem but the format I have is yyyymmdd
> >> >> example
> >> >> 20011214
> >> >> colum B:3 to B:439
> >> >> Thanks
> >> >>
> >> >> "jimbo693" <jimbo693.1d7xom@excelforum-nospam.com> wrote in message
> >> >> news:jimbo693.1d7xom@excelforum-nospam.com...
> >> >> >
> >> >> > i need to convert large groups of numbers into dates automatically
> >> >> > but
> >> >> > im stumped, the numbers are all in the format of 10.01.99 so they
> >> >> > read
> >> >> > as dates but excel wont recognise them as dates is there a way to
> >> >> > convert them all quickly to actual dates
> >> >> >
> >> >> >
> >> >> > --
> >> >> > jimbo693
> >> >> > ------------------------------------------------------------------------
> >> >> > jimbo693's Profile:
> >> >> > http://www.excelforum.com/member.php?action=getinfo&userid=14215
> >> >> > View this thread:
> >> >> > http://www.excelforum.com/showthread.php?threadid=263696
> >> >> >
> >> >
> >> > --
> >> >
> >> > Dave Peterson
> >> > ec35720@msn.com
> >
> > --
> >
> > Dave Peterson
> > ec35720@msn.com 

-- 
Dave Peterson
ec35720@msn.com