S
susan
I have noticed that anytime I copy a date from one excel spread sheet into
another it automatically changes the year to "12". When I tried to do a
custom set up and use mm/xx/08 instead of mm/xx/yy it wouldn't allow this
and showed the sample as 9/01/12. is it possible that in setting the example
as "12" for the year that all cells set up in this format are automatically
copied as "12" instead of picking up the original text? you might want to
check with the programmers, but this error is costing me hours every month
when working on a group invoice.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...122018&dg=microsoft.public.access.formscoding
another it automatically changes the year to "12". When I tried to do a
custom set up and use mm/xx/08 instead of mm/xx/yy it wouldn't allow this
and showed the sample as 9/01/12. is it possible that in setting the example
as "12" for the year that all cells set up in this format are automatically
copied as "12" instead of picking up the original text? you might want to
check with the programmers, but this error is costing me hours every month
when working on a group invoice.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...122018&dg=microsoft.public.access.formscoding