Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date Formula changes
I created a excel spread sheet which I emailed to someone at another
location and after they received it a cell which had the date format changed to a custom format. I have run across similar problems before with the same issue, can anyone tell me why this happens and how can I fix it? -- Jim Salyer 670-4138 I deny the allegations that during my last golf game I hit an eagle, a birdie, an elk and a moose |
#2
|
|||
|
|||
Are both you and your email recipient using the same versions of Excel?
Vaya con Dios, Chuck, CABGx3 "big jim" wrote in message ... I created a excel spread sheet which I emailed to someone at another location and after they received it a cell which had the date format changed to a custom format. I have run across similar problems before with the same issue, can anyone tell me why this happens and how can I fix it? -- Jim Salyer 670-4138 I deny the allegations that during my last golf game I hit an eagle, a birdie, an elk and a moose |
#3
|
|||
|
|||
I have excel 2002 (10.6501.6714) SP3 and the other location has excel 2002
(10.2614.2625) Jim S "CLR" wrote in message ... Are both you and your email recipient using the same versions of Excel? Vaya con Dios, Chuck, CABGx3 "big jim" wrote in message ... I created a excel spread sheet which I emailed to someone at another location and after they received it a cell which had the date format changed to a custom format. I have run across similar problems before with the same issue, can anyone tell me why this happens and how can I fix it? -- Jim Salyer 670-4138 I deny the allegations that during my last golf game I hit an eagle, a birdie, an elk and a moose |
#4
|
|||
|
|||
jim
What sort of change? From what to what? Are regional options setttings the same on both computers? Are ToolsOptionsCalculation "1904 date system" options the same? Gord Dibben Excel MVP On Sun, 6 Mar 2005 10:30:17 -0700, "big jim" wrote: I created a excel spread sheet which I emailed to someone at another location and after they received it a cell which had the date format changed to a custom format. I have run across similar problems before with the same issue, can anyone tell me why this happens and how can I fix it? |
#5
|
|||
|
|||
The regional options settings are the same on both computers, neither
computer has 1904 date system checked and the other options are the same. I formatted the cell as "date" and *3/14/2001 and when I sent it the format was set in the same cell as "custom" and d-mmm. Jim S "Gord Dibben" <gorddibbATshawDOTca wrote in message ... jim What sort of change? From what to what? Are regional options setttings the same on both computers? Are ToolsOptionsCalculation "1904 date system" options the same? Gord Dibben Excel MVP On Sun, 6 Mar 2005 10:30:17 -0700, "big jim" wrote: I created a excel spread sheet which I emailed to someone at another location and after they received it a cell which had the date format changed to a custom format. I have run across similar problems before with the same issue, can anyone tell me why this happens and how can I fix it? |
#6
|
|||
|
|||
"big jim" wrote in message ... The regional options settings are the same on both computers, neither computer has 1904 date system checked and the other options are the same. I formatted the cell as "date" and *3/14/2001 and when I sent it to them the format changed to "custom" and d-mmm. Jim S "Gord Dibben" <gorddibbATshawDOTca wrote in message ... jim What sort of change? From what to what? Are regional options setttings the same on both computers? Are ToolsOptionsCalculation "1904 date system" options the same? Gord Dibben Excel MVP On Sun, 6 Mar 2005 10:30:17 -0700, "big jim" wrote: I created a excel spread sheet which I emailed to someone at another location and after they received it a cell which had the date format changed to a custom format. I have run across similar problems before with the same issue, can anyone tell me why this happens and how can I fix it? |
#7
|
|||
|
|||
Jim
No more ideas for you from this quarter. Gord On Sun, 6 Mar 2005 12:32:55 -0700, "big jim" wrote: The regional options settings are the same on both computers, neither computer has 1904 date system checked and the other options are the same. I formatted the cell as "date" and *3/14/2001 and when I sent it the format was set in the same cell as "custom" and d-mmm. Jim S "Gord Dibben" <gorddibbATshawDOTca wrote in message .. . jim What sort of change? From what to what? Are regional options setttings the same on both computers? Are ToolsOptionsCalculation "1904 date system" options the same? Gord Dibben Excel MVP On Sun, 6 Mar 2005 10:30:17 -0700, "big jim" wrote: I created a excel spread sheet which I emailed to someone at another location and after they received it a cell which had the date format changed to a custom format. I have run across similar problems before with the same issue, can anyone tell me why this happens and how can I fix it? |
#8
|
|||
|
|||
You may have been hit by a coincidence.
When you do Format|cells|Number tab and look at that cell's format, I'm betting you see something like: *03/14/2001 That asterisk means that you chose a short date format that is picked up from the Windows Regional settings (Date tab). xl2002+ is more honest with the way it deals with dates. At the bottom of that dialog (xl2002): Date formats display date and time serial numbers as date values. Except for items that have an asterisk (*), applied formats do not switch date orders with the operating system. Since yours is marked with an asterisk, your date will switch formats with the setting in the OS. And maybe that other user is using a different short date format (in their windows regional settings). big jim wrote: The regional options settings are the same on both computers, neither computer has 1904 date system checked and the other options are the same. I formatted the cell as "date" and *3/14/2001 and when I sent it the format was set in the same cell as "custom" and d-mmm. Jim S "Gord Dibben" <gorddibbATshawDOTca wrote in message ... jim What sort of change? From what to what? Are regional options setttings the same on both computers? Are ToolsOptionsCalculation "1904 date system" options the same? Gord Dibben Excel MVP On Sun, 6 Mar 2005 10:30:17 -0700, "big jim" wrote: I created a excel spread sheet which I emailed to someone at another location and after they received it a cell which had the date format changed to a custom format. I have run across similar problems before with the same issue, can anyone tell me why this happens and how can I fix it? -- Dave Peterson |
#9
|
|||
|
|||
Thanks for your help
Jim "Dave Peterson" wrote in message ... You may have been hit by a coincidence. When you do Format|cells|Number tab and look at that cell's format, I'm betting you see something like: *03/14/2001 That asterisk means that you chose a short date format that is picked up from the Windows Regional settings (Date tab). xl2002+ is more honest with the way it deals with dates. At the bottom of that dialog (xl2002): Date formats display date and time serial numbers as date values. Except for items that have an asterisk (*), applied formats do not switch date orders with the operating system. Since yours is marked with an asterisk, your date will switch formats with the setting in the OS. And maybe that other user is using a different short date format (in their windows regional settings). big jim wrote: The regional options settings are the same on both computers, neither computer has 1904 date system checked and the other options are the same. I formatted the cell as "date" and *3/14/2001 and when I sent it the format was set in the same cell as "custom" and d-mmm. Jim S "Gord Dibben" <gorddibbATshawDOTca wrote in message ... jim What sort of change? From what to what? Are regional options setttings the same on both computers? Are ToolsOptionsCalculation "1904 date system" options the same? Gord Dibben Excel MVP On Sun, 6 Mar 2005 10:30:17 -0700, "big jim" wrote: I created a excel spread sheet which I emailed to someone at another location and after they received it a cell which had the date format changed to a custom format. I have run across similar problems before with the same issue, can anyone tell me why this happens and how can I fix it? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date formula | Excel Worksheet Functions | |||
Date Formula | Excel Discussion (Misc queries) | |||
Formula to determine a future date based on criteria | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) |