Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
why do dates change on graphs when emailing to another person
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
why do dates change on graphs when emailing to another person
Who knows with such an ambiguous problem statement?
How are the dates changing? If the difference is 4 years and 1 day, it's because the users have a different Date system selected (Tools/Options/Calculation). It could be that there's a NOW() or TODAY() function (or some other volatile function such as RAND()) in the data range. It could be that there's a macro operating. It could be user intervention. Does it happen with all users? Do you have any automacros or event macros in the workbook? Do you have any volatile functions in the data range? In article , rodger wrote: |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
why do dates change on graphs when emailing to another person
Do the dates change or do they just change the way they're displayed.
January 23, 2003 and 01/23/2003 could represent the same value. rodger wrote: -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
why do dates change on graphs when emailing to another person
the display changes on the graph, instead of Jan-06 it might read 389001 or
something, the data worksheet would be right. Also another problem is when typing in data in a cell formated for date I would type 1/06 it would display Jan 06 in the cell but up at the tool bar on the worksheet it would read 1/5/2006. "Dave Peterson" wrote: Do the dates change or do they just change the way they're displayed. January 23, 2003 and 01/23/2003 could represent the same value. rodger wrote: -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
why do dates change on graphs when emailing to another person
When I type
Jan 06 in a cell, I get January 6th, of the current year. Is that what you meant? I've found it's always better to fully type the date in the cell (year, month and day). ===== And formatting a cell only changes the way you see what's in that cell. The actual value doesn't change. And to excel, a date is just a number of days from a starting date. Usually it's the number of days since December 31, 1899 (for wintel users). I've never seen dates that change to general, though. If you don't get a good answer here, you may want to try the .charting newsgroup. rodger wrote: the display changes on the graph, instead of Jan-06 it might read 389001 or something, the data worksheet would be right. Also another problem is when typing in data in a cell formated for date I would type 1/06 it would display Jan 06 in the cell but up at the tool bar on the worksheet it would read 1/5/2006. "Dave Peterson" wrote: Do the dates change or do they just change the way they're displayed. January 23, 2003 and 01/23/2003 could represent the same value. rodger wrote: -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I change a column of dates from USA to UK format? | Excel Discussion (Misc queries) | |||
In Excel spreadsheeet the dates change to the wrong date after we. | Excel Discussion (Misc queries) | |||
Why does Excel Copy and Paste change dates from the original when. | Excel Discussion (Misc queries) | |||
how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) |