How do I format cells from numerical dates to text month in a dif.

#1 04-11-2005, 05:06 AM

I am trying to split dates into different cells for a chart however when the
month is formated for text it always reads January. Any help please

#2 04-11-2005, 11:06 AM

a bit more explanation please

--
Don Guillett
SalesAid Software
donaldb@281.com
"johntokay" <johntokay@discussions.microsoft.com> wrote in message
news:5923F28E-0DBF-4181-9DE4-7BD6A2E34413@microsoft.com...
> I am trying to split dates into different cells for a chart however when
the
> month is formated for text it always reads January. Any help please
>

#3 04-11-2005, 02:06 PM

In column A there is a list of dates thusly formatted: 01/30/2000,
01/31/2000, 02/01/2000, 02/02/2000. In column B there is some other
information needed for the chart. For chart purposes I what to split the
dates out into seperate colums C for year, D for month, E for day, and
finally F Day of the week. When trying to put the month column into text
instead of numerical everything comes up January. I have tried to change the
value to 5 in an individual cell and still get January when the sheet should
change to May.
BTW: Thanks for you consideration.

"Don Guillett" wrote:

> a bit more explanation please
>
> --
> Don Guillett
> SalesAid Software
> donaldb@281.com
> "johntokay" <johntokay@discussions.microsoft.com> wrote in message
> news:5923F28E-0DBF-4181-9DE4-7BD6A2E34413@microsoft.com...
> > I am trying to split dates into different cells for a chart however when
> the
> > month is formated for text it always reads January. Any help please
> >
>
>
>

#4 04-11-2005, 03:06 PM

try this if column A is properly formatted dates

=year(a1)
=month(a1)
=day(a1)
=format(a1,"dddd")

--
Don Guillett
SalesAid Software
donaldb@281.com
"johntokay" <johntokay@discussions.microsoft.com> wrote in message
news:57F2BB71-87C7-406E-AF19-2ED4250F7417@microsoft.com...
> In column A there is a list of dates thusly formatted: 01/30/2000,
> 01/31/2000, 02/01/2000, 02/02/2000. In column B there is some other
> information needed for the chart. For chart purposes I what to split the
> dates out into seperate colums C for year, D for month, E for day, and
> finally F Day of the week. When trying to put the month column into text
> instead of numerical everything comes up January. I have tried to change
the
> value to 5 in an individual cell and still get January when the sheet
should
> change to May.
> BTW: Thanks for you consideration.
>
> "Don Guillett" wrote:
>
> > a bit more explanation please
> >
> > --
> > Don Guillett
> > SalesAid Software
> > donaldb@281.com
> > "johntokay" <johntokay@discussions.microsoft.com> wrote in message
> > news:5923F28E-0DBF-4181-9DE4-7BD6A2E34413@microsoft.com...
> > > I am trying to split dates into different cells for a chart however
when
> > the
> > > month is formated for text it always reads January. Any help please
> > >
> >
> >
> >

#5 04-11-2005, 06:06 PM

Your suggestion works great for the days of the week, but not the months, I
tried =month(A1) and formatting for text month, everything changes to January
in office 2003 excell for me :-(

"Don Guillett" wrote:

> try this if column A is properly formatted dates
>
> =year(a1)
> =month(a1)
> =day(a1)
> =format(a1,"dddd")
>
> --
> Don Guillett
> SalesAid Software
> donaldb@281.com
> "johntokay" <johntokay@discussions.microsoft.com> wrote in message
> news:57F2BB71-87C7-406E-AF19-2ED4250F7417@microsoft.com...
> > In column A there is a list of dates thusly formatted: 01/30/2000,
> > 01/31/2000, 02/01/2000, 02/02/2000. In column B there is some other
> > information needed for the chart. For chart purposes I what to split the
> > dates out into seperate colums C for year, D for month, E for day, and
> > finally F Day of the week. When trying to put the month column into text
> > instead of numerical everything comes up January. I have tried to change
> the
> > value to 5 in an individual cell and still get January when the sheet
> should
> > change to May.
> > BTW: Thanks for you consideration.
> >
> > "Don Guillett" wrote:
> >
> > > a bit more explanation please
> > >
> > > --
> > > Don Guillett
> > > SalesAid Software
> > > donaldb@281.com
> > > "johntokay" <johntokay@discussions.microsoft.com> wrote in message
> > > news:5923F28E-0DBF-4181-9DE4-7BD6A2E34413@microsoft.com...
> > > > I am trying to split dates into different cells for a chart however
> when
> > > the
> > > > month is formated for text it always reads January. Any help please
> > > >
> > >
> > >
> > >
>
>
>

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)