 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2007Very strange date format behavior: 06 > 2006 / 07 > 07
I have to cells formatted as date dd-mm-yy. I one cell when I fill in dd-mm-06 I get dd-mm-2006 I the other cell when I fill in dd-mm-07 I get dd-mm-07 Only a format "Text" solves this problem. How can it happen?? I haven't find out with other dates and formats. Bart Ex 2003 Hi What happens if you click on the cell showing dd-mm-07, click the Format Painter icon, and "paint" over the cell showing dd-mm-2006? Does that cure the problem?  SignatureRegards Roger Govier >I have to cells formatted as date dd-mm-yy. > [quoted text clipped - 7 lines] > Bart > Ex 2003 On Jan 30, 1:47 pm, "Roger Govier" <r...@technologyNOSPAM4u.co.uk> wrote: > Hi > [quoted text clipped - 22 lines] > > Bart > > Ex 2003 I indeed have tried the Painter because thats the only tool to get all formats synchronized. But without success. Hi If you would like to mail a copy direct to me, I would be happy to take a look and see if I can spot the problem. To send direct remove NOSPAM from my address. SignatureRegards Roger Govier > On Jan 30, 1:47 pm, "Roger Govier" <r...@technologyNOSPAM4u.co.uk> > wrote: [quoted text clipped - 29 lines] > I indeed have tried the Painter because thats the only tool to get all > formats synchronized. But without success. On Jan 30, 2:39 pm, "Roger Govier" <r...@technologyNOSPAM4u.co.uk> wrote: > Hi > [quoted text clipped - 44 lines] > > I indeed have tried the Painter because thats the only tool to get all > > formats synchronized. But without success. Thanks Rogier, I will do. What is your name before the @ ? roger SignatureRegards Roger Govier > On Jan 30, 2:39 pm, "Roger Govier" <r...@technologyNOSPAM4u.co.uk> > wrote: [quoted text clipped - 50 lines] > > Thanks Rogier, I will do. What is your name before the @ ?
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.