Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date Format
The digits typed do not match the output, I wonder why.
I also tried to type 000000 and that defaulted to Jan1 1900. then I input 010101 which results into 8/27/27 , for 8/27/1927. this really baffles me, as I tried to Clear All to no avail. thanks for your help |
#2
|
|||
|
|||
I'm having the same problem. 12-17-04 comes in as 03-18-33, 12-14-03 =
08-25-29. IF I enter the same date again, the same wrong date is in the column. I have repeatedly reformatted with no success. Also checked the help site...no help there either. Any ideas? Someone please help ASAP "itqueencanada" wrote: The digits typed do not match the output, I wonder why. I also tried to type 000000 and that defaulted to Jan1 1900. then I input 010101 which results into 8/27/27 , for 8/27/1927. this really baffles me, as I tried to Clear All to no avail. thanks for your help |
#3
|
|||
|
|||
You may want to read about how excel treats dates (and times, too) at Chip
Pearson's site: http://www.cpearson.com/excel/datetime.htm You'll see why you need to either enter the slashes (or dashes) or have something else convert it for you (a macro or a formula). hsrosebud wrote: I'm having the same problem. 12-17-04 comes in as 03-18-33, 12-14-03 = 08-25-29. IF I enter the same date again, the same wrong date is in the column. I have repeatedly reformatted with no success. Also checked the help site...no help there either. Any ideas? Someone please help ASAP "itqueencanada" wrote: The digits typed do not match the output, I wonder why. I also tried to type 000000 and that defaulted to Jan1 1900. then I input 010101 which results into 8/27/27 , for 8/27/1927. this really baffles me, as I tried to Clear All to no avail. thanks for your help -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format date dd.mm.yyyy to dd/mm/yyyy | Excel Discussion (Misc queries) | |||
USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
Date format collapses diagram | Excel Discussion (Misc queries) | |||
prevent 4/5 in a cell automatically transfer to a date format | Excel Discussion (Misc queries) | |||
Problem with Date format from VBA code | Excel Discussion (Misc queries) |