Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Incorrect day displayed when merging data
Using an excel worksheet of data which includes dates - dates 'formated'
using e.g. "Wednseday, April 5 2006" are actually displayed as "Thursday, April 5 2006". When choosing fields to include in the merge the date is already corrupted as above. I tried various dates and the same issues occurs. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Incorrect day displayed when merging data
Are you sure it's Thursday, April 5 2006, or is it really Thursday,
April 4, 2002? The former makes no sense. The second one could come from a conversion from the 1904 date system to the 1900 date system. If you're copying data from a workbook in the 1904 system to one in the 1900 system, that would occur as well. In article , toto wrote: Using an excel worksheet of data which includes dates - dates 'formated' using e.g. "Wednseday, April 5 2006" are actually displayed as "Thursday, April 5 2006". When choosing fields to include in the merge the date is already corrupted as above. I tried various dates and the same issues occurs. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Incorrect day displayed when merging data
It is definitely "Thursday, April 5 2006", i.e. 2006. Though as I said
before, the original formated cell is correct, "Wednesdat, April 5 2006". "JE McGimpsey" wrote: Are you sure it's Thursday, April 5 2006, or is it really Thursday, April 4, 2002? The former makes no sense. The second one could come from a conversion from the 1904 date system to the 1900 date system. If you're copying data from a workbook in the 1904 system to one in the 1900 system, that would occur as well. In article , toto wrote: Using an excel worksheet of data which includes dates - dates 'formated' using e.g. "Wednseday, April 5 2006" are actually displayed as "Thursday, April 5 2006". When choosing fields to include in the merge the date is already corrupted as above. I tried various dates and the same issues occurs. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Incorrect day displayed when merging data
Have fixed the problem in the interim by amending the 'toggle field code' as
follows: {mergefiled "event_date" \@ "dddd, MMMM d, yyyy"} "toto" wrote: It is definitely "Thursday, April 5 2006", i.e. 2006. Though as I said before, the original formated cell is correct, "Wednesdat, April 5 2006". "JE McGimpsey" wrote: Are you sure it's Thursday, April 5 2006, or is it really Thursday, April 4, 2002? The former makes no sense. The second one could come from a conversion from the 1904 date system to the 1900 date system. If you're copying data from a workbook in the 1904 system to one in the 1900 system, that would occur as well. In article , toto wrote: Using an excel worksheet of data which includes dates - dates 'formated' using e.g. "Wednseday, April 5 2006" are actually displayed as "Thursday, April 5 2006". When choosing fields to include in the merge the date is already corrupted as above. I tried various dates and the same issues occurs. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Incorrect day displayed when merging data
What was it before?
In article , toto wrote: Have fixed the problem in the interim by amending the 'toggle field code' as follows: {mergefiled "event_date" \@ "dddd, MMMM d, yyyy"} |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to add data labels from a series not displayed on a chart | Charts and Charting in Excel | |||
Incorrect Currency Displayed | Excel Discussion (Misc queries) | |||
merging into Word with filtered data | Excel Discussion (Misc queries) | |||
Merging columns of data | Excel Discussion (Misc queries) | |||
Merging columns of data | Excel Discussion (Misc queries) |