LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Formatting Dates in Excel

When I try to enter a date in my spreadsheet such as 02022007 (02/02/2007)
and hit enter it inputs 09/12/1956???? I have no idea where this value comes
from. Is there a place where values for formats can be changed?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Weird Excel date formatting problem Ian D New Users to Excel 2 October 21st 05 03:30 PM
Excel changing number formatting and source data in graphs on it's own!!! JohnHamer Excel Discussion (Misc queries) 2 September 22nd 05 02:29 PM
Excel 2003 Trashes Imported Dates KymY Excel Discussion (Misc queries) 3 April 27th 05 02:34 PM
Excel error - remove some formatting Jason Morin Excel Discussion (Misc queries) 0 March 11th 05 02:42 PM
Conditional Formatting in Excel Help Please..... Willie T Excel Discussion (Misc queries) 4 February 9th 05 02:28 PM


All times are GMT +1. The time now is 10:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"