Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formatting
I have never had this problem before, and now, all of a sudden ..!! I'm
frustrated! Ok..here's what's going on: What I'm trying to do, is format a column of cells, or even just an individual cell, to display a date as mm/dd/yy. I remember doing this before, and only having to type in, for example, 010106 if I want the cell to display 01/01/06 (which obviously woudl be for January 1, 2006). What's happening is, after i type in my numbers, and hit enter to move on to the next cell- it changes it for some reason. If i type in 010106 into a date formatted cell, it displays "09/01/27". What's going on, and how can I fix it? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formatting
Hi!
010106 is being evaluated as 10106 which is serial date 09/01/27 (Sept 1 1927). See this: http://cpearson.com/excel/DateTimeEntry.htm Biff "Katie" wrote in message ... I have never had this problem before, and now, all of a sudden ..!! I'm frustrated! Ok..here's what's going on: What I'm trying to do, is format a column of cells, or even just an individual cell, to display a date as mm/dd/yy. I remember doing this before, and only having to type in, for example, 010106 if I want the cell to display 01/01/06 (which obviously woudl be for January 1, 2006). What's happening is, after i type in my numbers, and hit enter to move on to the next cell- it changes it for some reason. If i type in 010106 into a date formatted cell, it displays "09/01/27". What's going on, and how can I fix it? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formatting
Katie
Don't know how you did it before, but Excel by default will not accept dates typed this way. See Chip Pearson's site for method of entering dates and times. http://www.cpearson.com/excel/DateTimeEntry.htm Or Bob Phillips' site for the QDE add-in. http://www.xldynamic.com/source/xld.QDEDownload.html Gord Dibben MS Excel MVP On Sat, 4 Nov 2006 11:55:01 -0800, Katie wrote: I have never had this problem before, and now, all of a sudden ..!! I'm frustrated! Ok..here's what's going on: What I'm trying to do, is format a column of cells, or even just an individual cell, to display a date as mm/dd/yy. I remember doing this before, and only having to type in, for example, 010106 if I want the cell to display 01/01/06 (which obviously woudl be for January 1, 2006). What's happening is, after i type in my numbers, and hit enter to move on to the next cell- it changes it for some reason. If i type in 010106 into a date formatted cell, it displays "09/01/27". What's going on, and how can I fix it? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formatting
But how do i FIX it? How SHOULD I type it? How do i get it to stop evaluating
it as a serial date? "Biff" wrote: Hi! 010106 is being evaluated as 10106 which is serial date 09/01/27 (Sept 1 1927). See this: http://cpearson.com/excel/DateTimeEntry.htm Biff "Katie" wrote in message ... I have never had this problem before, and now, all of a sudden ..!! I'm frustrated! Ok..here's what's going on: What I'm trying to do, is format a column of cells, or even just an individual cell, to display a date as mm/dd/yy. I remember doing this before, and only having to type in, for example, 010106 if I want the cell to display 01/01/06 (which obviously woudl be for January 1, 2006). What's happening is, after i type in my numbers, and hit enter to move on to the next cell- it changes it for some reason. If i type in 010106 into a date formatted cell, it displays "09/01/27". What's going on, and how can I fix it? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formatting
Type it as 01/01/06 (or you can probably get away with 1/1/06).
-- David Biddulph "Katie" wrote in message ... But how do i FIX it? How SHOULD I type it? How do i get it to stop evaluating it as a serial date? "Biff" wrote: Hi! 010106 is being evaluated as 10106 which is serial date 09/01/27 (Sept 1 1927). See this: http://cpearson.com/excel/DateTimeEntry.htm Biff "Katie" wrote in message ... I have never had this problem before, and now, all of a sudden ..!! I'm frustrated! Ok..here's what's going on: What I'm trying to do, is format a column of cells, or even just an individual cell, to display a date as mm/dd/yy. I remember doing this before, and only having to type in, for example, 010106 if I want the cell to display 01/01/06 (which obviously woudl be for January 1, 2006). What's happening is, after i type in my numbers, and hit enter to move on to the next cell- it changes it for some reason. If i type in 010106 into a date formatted cell, it displays "09/01/27". What's going on, and how can I fix it? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date formatting
If you want to enter the date as a sting like 010106 and have it
automatically change to a date like 01/01/06 requires an event change macro. See the instructions provided in the link. http://cpearson.com/excel/DateTimeEntry.htm Biff "Katie" wrote in message ... But how do i FIX it? How SHOULD I type it? How do i get it to stop evaluating it as a serial date? "Biff" wrote: Hi! 010106 is being evaluated as 10106 which is serial date 09/01/27 (Sept 1 1927). See this: http://cpearson.com/excel/DateTimeEntry.htm Biff "Katie" wrote in message ... I have never had this problem before, and now, all of a sudden ..!! I'm frustrated! Ok..here's what's going on: What I'm trying to do, is format a column of cells, or even just an individual cell, to display a date as mm/dd/yy. I remember doing this before, and only having to type in, for example, 010106 if I want the cell to display 01/01/06 (which obviously woudl be for January 1, 2006). What's happening is, after i type in my numbers, and hit enter to move on to the next cell- it changes it for some reason. If i type in 010106 into a date formatted cell, it displays "09/01/27". What's going on, and how can I fix it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Date for Sorting | Excel Discussion (Misc queries) | |||
Date formatting help | Excel Discussion (Misc queries) | |||
Can a date be used for conditional formatting? | Excel Worksheet Functions | |||
Conditional Formatting, date. | Excel Worksheet Functions | |||
Despite formatting a column in Excel 2002 worksheet as Short Date. | Excel Discussion (Misc queries) |