Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Date formating problem in EXCEL 2003 Date formating problem in EXCEL 2003
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 01-04-2012, 11:34 PM
Catalin.B Catalin.B is offline Date formating problem in EXCEL 2003 Windows Vista Date formating problem in EXCEL 2003 Office 2010 32bit
Expert
  
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

Can you upload a sample of your worksheet that reproduces this problem?
Reply With Quote
  #2  
Old 01-05-2012, 07:05 AM
lyngio lyngio is offline Date formating problem in EXCEL 2003 Windows XP Date formating problem in EXCEL 2003 Office 2003
Novice
Date formating problem in EXCEL 2003 		 
Join Date: Jan 2012
Posts: 6
lyngio is on a distinguished road
Unhappy
Quote:
Originally Posted by Catalin.B View Post
Can you upload a sample of your worksheet that reproduces this problem?
See attached
Attached Files
File Type: xls Book1.xls (74.0 KB, 16 views)
Reply With Quote
  #3  
Old 01-05-2012, 07:36 AM
Catalin.B Catalin.B is offline Date formating problem in EXCEL 2003 Windows Vista Date formating problem in EXCEL 2003 Office 2010 32bit
Expert
  
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default
My guess it's only from regional settings...
Have another check of those settings:
control panel--> regional and language options-->formats tab (pay attention to the date samples , does it show for today , short date 5/1/2012 ? If not, click Customise this format button on this tab, then Date Tab. I cannot see another reason...
Reply With Quote
  #4  
Old 01-05-2012, 08:57 AM
lyngio lyngio is offline Date formating problem in EXCEL 2003 Windows XP Date formating problem in EXCEL 2003 Office 2003
Novice
Date formating problem in EXCEL 2003 		 
Join Date: Jan 2012
Posts: 6
lyngio is on a distinguished road
Default
Quote:
Originally Posted by Catalin.B View Post
My guess it's only from regional settings...
Have another check of those settings:
control panel--> regional and language options-->formats tab (pay attention to the date samples , does it show for today , short date 5/1/2012 ? If not, click Customise this format button on this tab, then Date Tab. I cannot see another reason...
Yes agreed.........I cannot understand why it is so
I have attached a screen dump of the said settings.
I even changed them to other versions of English and back to the current (Australia) but alas no good.........Got me stumped!


Anyone else out there have any idea??? Heeeeeellllllppppp....
Attached Files
File Type: doc Doc1.doc (57.5 KB, 13 views)
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date formating problem in EXCEL 2003 word 2003 date picker nashville Word 16 04-06-2012 04:12 AM
Date formating problem in EXCEL 2003 Problem with opening xlsm in excel 2003 cryjoh Excel 2 12-13-2011 11:49 AM
Excel 2003 / 2007 files saving slow on Win 2003 Server Atradius Office 0 07-23-2011 07:41 AM
Date formating problem in EXCEL 2003 Excel 07 formating 17 cells "Need Formula" Raner Excel 2 05-30-2010 02:07 PM
Date formating problem in EXCEL 2003 Excel Date Alert? Kelleigh Excel 1 12-05-2008 09:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:41 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft