Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date problems
When I put in a date on the spread sheet, for instance 11/10/06 it comes out
12/03/03. In the formula bar, it say 12/03/2203. Excell worked fine a week ago. I tried clearing the cell, went to format for date 11/11/06 is what I want to use. I even opened a new spread sheet and the same thing happens. My computer date is fine, dont know what else to check. Any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
date problems
Is the difference always the same.........if you type in 11/11/06 does it
display 12/04/03, etc.......... Do yo have any file that starts up automatically when XL starts?.......if so, perhaps a start-up macro is doing it? hth Vaya con Dios, Chuck, CABGx3 "piute" wrote: When I put in a date on the spread sheet, for instance 11/10/06 it comes out 12/03/03. In the formula bar, it say 12/03/2203. Excell worked fine a week ago. I tried clearing the cell, went to format for date 11/11/06 is what I want to use. I even opened a new spread sheet and the same thing happens. My computer date is fine, dont know what else to check. Any suggestions? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
date problems
no, it comes up 03/12/04 and in the top bar it says 03/12/2204
"CLR" wrote: Is the difference always the same.........if you type in 11/11/06 does it display 12/04/03, etc.......... Do yo have any file that starts up automatically when XL starts?.......if so, perhaps a start-up macro is doing it? hth Vaya con Dios, Chuck, CABGx3 "piute" wrote: When I put in a date on the spread sheet, for instance 11/10/06 it comes out 12/03/03. In the formula bar, it say 12/03/2203. Excell worked fine a week ago. I tried clearing the cell, went to format for date 11/11/06 is what I want to use. I even opened a new spread sheet and the same thing happens. My computer date is fine, dont know what else to check. Any suggestions? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
date problems
no file starts up and dont use macros
"CLR" wrote: Is the difference always the same.........if you type in 11/11/06 does it display 12/04/03, etc.......... Do yo have any file that starts up automatically when XL starts?.......if so, perhaps a start-up macro is doing it? hth Vaya con Dios, Chuck, CABGx3 "piute" wrote: When I put in a date on the spread sheet, for instance 11/10/06 it comes out 12/03/03. In the formula bar, it say 12/03/2203. Excell worked fine a week ago. I tried clearing the cell, went to format for date 11/11/06 is what I want to use. I even opened a new spread sheet and the same thing happens. My computer date is fine, dont know what else to check. Any suggestions? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
date problems
Durned if I know.......with no macros or formulas in play and just typing the
date in a new sheet and getting such inconsistant deviations..........only thing I can think of is a corrupt install of Excel..........sorry. Vaya con Dios, Chuck, CABGx3 "piute" wrote: no, it comes up 03/12/04 and in the top bar it says 03/12/2204 "CLR" wrote: Is the difference always the same.........if you type in 11/11/06 does it display 12/04/03, etc.......... Do yo have any file that starts up automatically when XL starts?.......if so, perhaps a start-up macro is doing it? hth Vaya con Dios, Chuck, CABGx3 "piute" wrote: When I put in a date on the spread sheet, for instance 11/10/06 it comes out 12/03/03. In the formula bar, it say 12/03/2203. Excell worked fine a week ago. I tried clearing the cell, went to format for date 11/11/06 is what I want to use. I even opened a new spread sheet and the same thing happens. My computer date is fine, dont know what else to check. Any suggestions? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
date problems
You say no macros, but I'd check.
Close excel windows start button|Run excel /safe file|Open yourworkbook.xls and test it out... And do you get the same problem with every workbook? piute wrote: no file starts up and dont use macros "CLR" wrote: Is the difference always the same.........if you type in 11/11/06 does it display 12/04/03, etc.......... Do yo have any file that starts up automatically when XL starts?.......if so, perhaps a start-up macro is doing it? hth Vaya con Dios, Chuck, CABGx3 "piute" wrote: When I put in a date on the spread sheet, for instance 11/10/06 it comes out 12/03/03. In the formula bar, it say 12/03/2203. Excell worked fine a week ago. I tried clearing the cell, went to format for date 11/11/06 is what I want to use. I even opened a new spread sheet and the same thing happens. My computer date is fine, dont know what else to check. Any suggestions? -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
date problems
I did use excel/safe and opened the workbook and typed in the date 11/11/06
and it still comes up with 03/12/04 in the cell and on the formula bar it says 3/12/2204 "Dave Peterson" wrote: You say no macros, but I'd check. Close excel windows start button|Run excel /safe file|Open yourworkbook.xls and test it out... And do you get the same problem with every workbook? piute wrote: no file starts up and dont use macros "CLR" wrote: Is the difference always the same.........if you type in 11/11/06 does it display 12/04/03, etc.......... Do yo have any file that starts up automatically when XL starts?.......if so, perhaps a start-up macro is doing it? hth Vaya con Dios, Chuck, CABGx3 "piute" wrote: When I put in a date on the spread sheet, for instance 11/10/06 it comes out 12/03/03. In the formula bar, it say 12/03/2203. Excell worked fine a week ago. I tried clearing the cell, went to format for date 11/11/06 is what I want to use. I even opened a new spread sheet and the same thing happens. My computer date is fine, dont know what else to check. Any suggestions? -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
date problems
Hi
If you type 111106 (no spaces, hyphens or slashes) into a cell preformatted as Date, then I get 12/03/2004. Don't ask me why as the serial date for 12/03/2004 is 38324 Try typing in 121106, 131106, 141106, 151106, 161106 and you get 29/07/2231 01/05/2286 17/09/2313 02/02/2341 20/06/2368 Very weird!!! -- Regards Roger Govier "CLR" wrote in message ... Durned if I know.......with no macros or formulas in play and just typing the date in a new sheet and getting such inconsistant deviations..........only thing I can think of is a corrupt install of Excel..........sorry. Vaya con Dios, Chuck, CABGx3 "piute" wrote: no, it comes up 03/12/04 and in the top bar it says 03/12/2204 "CLR" wrote: Is the difference always the same.........if you type in 11/11/06 does it display 12/04/03, etc.......... Do yo have any file that starts up automatically when XL starts?.......if so, perhaps a start-up macro is doing it? hth Vaya con Dios, Chuck, CABGx3 "piute" wrote: When I put in a date on the spread sheet, for instance 11/10/06 it comes out 12/03/03. In the formula bar, it say 12/03/2203. Excell worked fine a week ago. I tried clearing the cell, went to format for date 11/11/06 is what I want to use. I even opened a new spread sheet and the same thing happens. My computer date is fine, dont know what else to check. Any suggestions? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
date problems
One more guess...
Anything in your Autocorrect list that would affect this? I still don't have a good idea. piute wrote: I did use excel/safe and opened the workbook and typed in the date 11/11/06 and it still comes up with 03/12/04 in the cell and on the formula bar it says 3/12/2204 "Dave Peterson" wrote: You say no macros, but I'd check. Close excel windows start button|Run excel /safe file|Open yourworkbook.xls and test it out... And do you get the same problem with every workbook? piute wrote: no file starts up and dont use macros "CLR" wrote: Is the difference always the same.........if you type in 11/11/06 does it display 12/04/03, etc.......... Do yo have any file that starts up automatically when XL starts?.......if so, perhaps a start-up macro is doing it? hth Vaya con Dios, Chuck, CABGx3 "piute" wrote: When I put in a date on the spread sheet, for instance 11/10/06 it comes out 12/03/03. In the formula bar, it say 12/03/2203. Excell worked fine a week ago. I tried clearing the cell, went to format for date 11/11/06 is what I want to use. I even opened a new spread sheet and the same thing happens. My computer date is fine, dont know what else to check. Any suggestions? -- Dave Peterson -- Dave Peterson |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
date problems
I see nothing in there . I tried a couple of things, but nothing has helped.
Every computer in this office is stand alone, and we all have the same problem. I wonder if some upgrade the puter automatically does could affect the spread sheet "Dave Peterson" wrote: One more guess... Anything in your Autocorrect list that would affect this? I still don't have a good idea. piute wrote: I did use excel/safe and opened the workbook and typed in the date 11/11/06 and it still comes up with 03/12/04 in the cell and on the formula bar it says 3/12/2204 "Dave Peterson" wrote: You say no macros, but I'd check. Close excel windows start button|Run excel /safe file|Open yourworkbook.xls and test it out... And do you get the same problem with every workbook? piute wrote: no file starts up and dont use macros "CLR" wrote: Is the difference always the same.........if you type in 11/11/06 does it display 12/04/03, etc.......... Do yo have any file that starts up automatically when XL starts?.......if so, perhaps a start-up macro is doing it? hth Vaya con Dios, Chuck, CABGx3 "piute" wrote: When I put in a date on the spread sheet, for instance 11/10/06 it comes out 12/03/03. In the formula bar, it say 12/03/2203. Excell worked fine a week ago. I tried clearing the cell, went to format for date 11/11/06 is what I want to use. I even opened a new spread sheet and the same thing happens. My computer date is fine, dont know what else to check. Any suggestions? -- Dave Peterson -- Dave Peterson |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
date problems
I typed in those numbers and get different ones than you. Wonder what is
wrong. Worked fine last week on my spread sheets, now this. "Roger Govier" wrote: Hi If you type 111106 (no spaces, hyphens or slashes) into a cell preformatted as Date, then I get 12/03/2004. Don't ask me why as the serial date for 12/03/2004 is 38324 Try typing in 121106, 131106, 141106, 151106, 161106 and you get 29/07/2231 01/05/2286 17/09/2313 02/02/2341 20/06/2368 Very weird!!! -- Regards Roger Govier "CLR" wrote in message ... Durned if I know.......with no macros or formulas in play and just typing the date in a new sheet and getting such inconsistant deviations..........only thing I can think of is a corrupt install of Excel..........sorry. Vaya con Dios, Chuck, CABGx3 "piute" wrote: no, it comes up 03/12/04 and in the top bar it says 03/12/2204 "CLR" wrote: Is the difference always the same.........if you type in 11/11/06 does it display 12/04/03, etc.......... Do yo have any file that starts up automatically when XL starts?.......if so, perhaps a start-up macro is doing it? hth Vaya con Dios, Chuck, CABGx3 "piute" wrote: When I put in a date on the spread sheet, for instance 11/10/06 it comes out 12/03/03. In the formula bar, it say 12/03/2203. Excell worked fine a week ago. I tried clearing the cell, went to format for date 11/11/06 is what I want to use. I even opened a new spread sheet and the same thing happens. My computer date is fine, dont know what else to check. Any suggestions? |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
date problems
You're not typing in those slashes, are you?
If you don't type in the slashes, then excel just sees it as a number: 111106 (111,106) Typing 111106 in a cell and giving that cell a format of a date, just means that you want the date that is 111,106 days after a base date (usually Dec 31, 1899 for wintel users). If I type 111106 in a cell that's formatted as a date, I get 03/12/2204. You've got to give excel some indication that you want a date. piute wrote: I see nothing in there . I tried a couple of things, but nothing has helped. Every computer in this office is stand alone, and we all have the same problem. I wonder if some upgrade the puter automatically does could affect the spread sheet "Dave Peterson" wrote: One more guess... Anything in your Autocorrect list that would affect this? I still don't have a good idea. piute wrote: I did use excel/safe and opened the workbook and typed in the date 11/11/06 and it still comes up with 03/12/04 in the cell and on the formula bar it says 3/12/2204 "Dave Peterson" wrote: You say no macros, but I'd check. Close excel windows start button|Run excel /safe file|Open yourworkbook.xls and test it out... And do you get the same problem with every workbook? piute wrote: no file starts up and dont use macros "CLR" wrote: Is the difference always the same.........if you type in 11/11/06 does it display 12/04/03, etc.......... Do yo have any file that starts up automatically when XL starts?.......if so, perhaps a start-up macro is doing it? hth Vaya con Dios, Chuck, CABGx3 "piute" wrote: When I put in a date on the spread sheet, for instance 11/10/06 it comes out 12/03/03. In the formula bar, it say 12/03/2203. Excell worked fine a week ago. I tried clearing the cell, went to format for date 11/11/06 is what I want to use. I even opened a new spread sheet and the same thing happens. My computer date is fine, dont know what else to check. Any suggestions? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
date problems
Hi
My mistake. Typing late last night, I read 12/03/04 as 12/03/2004 as opposed to 12/03/2204. The serial date for 12/03/2204 (that's 12 March 2204) is 111106, which is what you entered into a cell. Following on with 121106 (which I did), is 10,000 days later, which correctly gives the date of 29/07/2231 Excel is behaving correctly, and treating a number entered to a date formatted cell as a serial date, then converting that to a calendar date. Apologies for the sloppy thinking late last night - put it down to old age and tiredness!!! -- Regards Roger Govier "piute" wrote in message ... I typed in those numbers and get different ones than you. Wonder what is wrong. Worked fine last week on my spread sheets, now this. "Roger Govier" wrote: Hi If you type 111106 (no spaces, hyphens or slashes) into a cell preformatted as Date, then I get 12/03/2004. Don't ask me why as the serial date for 12/03/2004 is 38324 Try typing in 121106, 131106, 141106, 151106, 161106 and you get 29/07/2231 01/05/2286 17/09/2313 02/02/2341 20/06/2368 Very weird!!! -- Regards Roger Govier "CLR" wrote in message ... Durned if I know.......with no macros or formulas in play and just typing the date in a new sheet and getting such inconsistant deviations..........only thing I can think of is a corrupt install of Excel..........sorry. Vaya con Dios, Chuck, CABGx3 "piute" wrote: no, it comes up 03/12/04 and in the top bar it says 03/12/2204 "CLR" wrote: Is the difference always the same.........if you type in 11/11/06 does it display 12/04/03, etc.......... Do yo have any file that starts up automatically when XL starts?.......if so, perhaps a start-up macro is doing it? hth Vaya con Dios, Chuck, CABGx3 "piute" wrote: When I put in a date on the spread sheet, for instance 11/10/06 it comes out 12/03/03. In the formula bar, it say 12/03/2203. Excell worked fine a week ago. I tried clearing the cell, went to format for date 11/11/06 is what I want to use. I even opened a new spread sheet and the same thing happens. My computer date is fine, dont know what else to check. Any suggestions? |
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
date problems
Good Detective work Dave..........!
Vaya con Dios, Chuck, CABGx3 "Dave Peterson" wrote: You're not typing in those slashes, are you? If you don't type in the slashes, then excel just sees it as a number: 111106 (111,106) Typing 111106 in a cell and giving that cell a format of a date, just means that you want the date that is 111,106 days after a base date (usually Dec 31, 1899 for wintel users). If I type 111106 in a cell that's formatted as a date, I get 03/12/2204. You've got to give excel some indication that you want a date. piute wrote: I see nothing in there . I tried a couple of things, but nothing has helped. Every computer in this office is stand alone, and we all have the same problem. I wonder if some upgrade the puter automatically does could affect the spread sheet "Dave Peterson" wrote: One more guess... Anything in your Autocorrect list that would affect this? I still don't have a good idea. piute wrote: I did use excel/safe and opened the workbook and typed in the date 11/11/06 and it still comes up with 03/12/04 in the cell and on the formula bar it says 3/12/2204 "Dave Peterson" wrote: You say no macros, but I'd check. Close excel windows start button|Run excel /safe file|Open yourworkbook.xls and test it out... And do you get the same problem with every workbook? piute wrote: no file starts up and dont use macros "CLR" wrote: Is the difference always the same.........if you type in 11/11/06 does it display 12/04/03, etc.......... Do yo have any file that starts up automatically when XL starts?.......if so, perhaps a start-up macro is doing it? hth Vaya con Dios, Chuck, CABGx3 "piute" wrote: When I put in a date on the spread sheet, for instance 11/10/06 it comes out 12/03/03. In the formula bar, it say 12/03/2203. Excell worked fine a week ago. I tried clearing the cell, went to format for date 11/11/06 is what I want to use. I even opened a new spread sheet and the same thing happens. My computer date is fine, dont know what else to check. Any suggestions? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#15
Posted to microsoft.public.excel.misc
|
|||
|
|||
date problems
I think we were all confused by the OP's statement that he typed in the date.
CLR wrote: Good Detective work Dave..........! Vaya con Dios, Chuck, CABGx3 "Dave Peterson" wrote: You're not typing in those slashes, are you? If you don't type in the slashes, then excel just sees it as a number: 111106 (111,106) Typing 111106 in a cell and giving that cell a format of a date, just means that you want the date that is 111,106 days after a base date (usually Dec 31, 1899 for wintel users). If I type 111106 in a cell that's formatted as a date, I get 03/12/2204. You've got to give excel some indication that you want a date. piute wrote: I see nothing in there . I tried a couple of things, but nothing has helped. Every computer in this office is stand alone, and we all have the same problem. I wonder if some upgrade the puter automatically does could affect the spread sheet "Dave Peterson" wrote: One more guess... Anything in your Autocorrect list that would affect this? I still don't have a good idea. piute wrote: I did use excel/safe and opened the workbook and typed in the date 11/11/06 and it still comes up with 03/12/04 in the cell and on the formula bar it says 3/12/2204 "Dave Peterson" wrote: You say no macros, but I'd check. Close excel windows start button|Run excel /safe file|Open yourworkbook.xls and test it out... And do you get the same problem with every workbook? piute wrote: no file starts up and dont use macros "CLR" wrote: Is the difference always the same.........if you type in 11/11/06 does it display 12/04/03, etc.......... Do yo have any file that starts up automatically when XL starts?.......if so, perhaps a start-up macro is doing it? hth Vaya con Dios, Chuck, CABGx3 "piute" wrote: When I put in a date on the spread sheet, for instance 11/10/06 it comes out 12/03/03. In the formula bar, it say 12/03/2203. Excell worked fine a week ago. I tried clearing the cell, went to format for date 11/11/06 is what I want to use. I even opened a new spread sheet and the same thing happens. My computer date is fine, dont know what else to check. Any suggestions? -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date problems, is it a bug??? | Excel Discussion (Misc queries) | |||
Mileage Claim Formula | New Users to Excel | |||
Date format problems | Charts and Charting in Excel | |||
Date Problems | Charts and Charting in Excel | |||
Date sort problems | Excel Discussion (Misc queries) |