Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
reformatting dates
10/3/2007
Thu Oct 4, 2007 Sat Oct 6, 2007 Tue Oct 9, 2007 Thu Oct 11, 2007 Sat Oct 13, 2007 Mon Oct 15, 2007 I have a series of dates....when I try to reformat them all to m/d/ yyyy only some of them are changing from the current expanded day month date, year The first one here changed but the others didn't. Any suggestions?? I'm thinking I might have to convert them all to something and then format to what I want. ....Lisa |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
reformatting dates
I'm guessing that you have text instead of numbers ni those cells. in an
adjacent column, put this formula and come back and let us know what you see. =ISNUMBER(A1) " wrote: 10/3/2007 Thu Oct 4, 2007 Sat Oct 6, 2007 Tue Oct 9, 2007 Thu Oct 11, 2007 Sat Oct 13, 2007 Mon Oct 15, 2007 I have a series of dates....when I try to reformat them all to m/d/ yyyy only some of them are changing from the current expanded day month date, year The first one here changed but the others didn't. Any suggestions?? I'm thinking I might have to convert them all to something and then format to what I want. ....Lisa |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
reformatting dates
I would assume the dates that don't change are text.
Try this.............. DataText to ColumnsFixed widthNext Double-click on the separation line you don't want leaving just the line between the day and the date. NextSelect Skip the column with days and Finish. Gord Dibben MS Excel MVP On Thu, 12 Jul 2007 06:57:07 -0700, " wrote: 10/3/2007 Thu Oct 4, 2007 Sat Oct 6, 2007 Tue Oct 9, 2007 Thu Oct 11, 2007 Sat Oct 13, 2007 Mon Oct 15, 2007 I have a series of dates....when I try to reformat them all to m/d/ yyyy only some of them are changing from the current expanded day month date, year The first one here changed but the others didn't. Any suggestions?? I'm thinking I might have to convert them all to something and then format to what I want. ...Lisa |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
reformatting dates
Most cells came back FALSE ....Lisa On Jul 12, 10:14 am, Barb Reinhardt wrote: I'm guessing that you have text instead of numbers ni those cells. in an adjacent column, put this formula and come back and let us know what you see. =ISNUMBER(A1) " wrote: 10/3/2007 Thu Oct 4, 2007 Sat Oct 6, 2007 Tue Oct 9, 2007 Thu Oct 11, 2007 Sat Oct 13, 2007 Mon Oct 15, 2007 I have a series of dates....when I try to reformat them all to m/d/ yyyy only some of them are changing from the current expanded day month date, year The first one here changed but the others didn't. Any suggestions?? I'm thinking I might have to convert them all to something and then format to what I want. ....Lisa |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
reformatting dates
I did this except I didn't see" Select Skip the column with days"
It didn't seem to change anything ....Lisa Not sure what I did wrong........ On Jul 12, 11:00 am, Gord Dibben <gorddibbATshawDOTca wrote: I would assume the dates that don't change are text. Try this.............. DataText to ColumnsFixed widthNext Double-click on the separation line you don't want leaving just the line between the day and the date. NextSelect Skip the column with days and Finish. Gord Dibben MS Excel MVP On Thu, 12 Jul 2007 06:57:07 -0700, " wrote: 10/3/2007 Thu Oct 4, 2007 Sat Oct 6, 2007 Tue Oct 9, 2007 Thu Oct 11, 2007 Sat Oct 13, 2007 Mon Oct 15, 2007 I have a series of dates....when I try to reformat them all to m/d/ yyyy only some of them are changing from the current expanded day month date, year The first one here changed but the others didn't. Any suggestions?? I'm thinking I might have to convert them all to something and then format to what I want. ...Lisa |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
reformatting dates
DataText to ColumnsFixed WidthNext. Double-click on the second break line to
eliminate the second break lineNext With the days column selectedColumn Data FormatDo not Import Column(Skip) Gord On Thu, 12 Jul 2007 08:43:15 -0700, " wrote: I did this except I didn't see" Select Skip the column with days" It didn't seem to change anything ...Lisa Not sure what I did wrong........ On Jul 12, 11:00 am, Gord Dibben <gorddibbATshawDOTca wrote: I would assume the dates that don't change are text. Try this.............. DataText to ColumnsFixed widthNext Double-click on the separation line you don't want leaving just the line between the day and the date. NextSelect Skip the column with days and Finish. Gord Dibben MS Excel MVP On Thu, 12 Jul 2007 06:57:07 -0700, " wrote: 10/3/2007 Thu Oct 4, 2007 Sat Oct 6, 2007 Tue Oct 9, 2007 Thu Oct 11, 2007 Sat Oct 13, 2007 Mon Oct 15, 2007 I have a series of dates....when I try to reformat them all to m/d/ yyyy only some of them are changing from the current expanded day month date, year The first one here changed but the others didn't. Any suggestions?? I'm thinking I might have to convert them all to something and then format to what I want. ...Lisa |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
reformatting dates
On Jul 12, 12:53 pm, Gord Dibben <gorddibbATshawDOTca wrote:
DataText to ColumnsFixed WidthNext. Double-click on the second break line to eliminate the second break lineNext With the days column selectedColumn Data FormatDo not Import Column(Skip) Gord On Thu, 12 Jul 2007 08:43:15 -0700, " wrote: I did this except I didn't see" Select Skip the column with days" It didn't seem to change anything ...Lisa Not sure what I did wrong........ On Jul 12, 11:00 am, Gord Dibben <gorddibbATshawDOTca wrote: I would assume the dates that don't change are text. Try this.............. DataText to ColumnsFixed widthNext Double-click on the separation line you don't want leaving just the line between the day and the date. NextSelect Skip the column with days and Finish. Gord Dibben MS Excel MVP On Thu, 12 Jul 2007 06:57:07 -0700, " wrote: 10/3/2007 Thu Oct 4, 2007 Sat Oct 6, 2007 Tue Oct 9, 2007 Thu Oct 11, 2007 Sat Oct 13, 2007 Mon Oct 15, 2007 I have a series of dates....when I try to reformat them all to m/d/ yyyy only some of them are changing from the current expanded day month date, year The first one here changed but the others didn't. Any suggestions?? I'm thinking I might have to convert them all to something and then format to what I want. ...Lisa Thank you!! ....Lisa |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reformatting dates for sorting | Excel Discussion (Misc queries) | |||
Reformatting a column | Excel Discussion (Misc queries) | |||
need help reformatting spreadsheet | Excel Discussion (Misc queries) | |||
Reformatting dates as text | Excel Worksheet Functions | |||
Reformatting formula | Excel Worksheet Functions |