Date Wont Change in Excel??!

laurahhh@gmail.com

Guest

Posts: n/a

18th Sep 2006

Hi, I have been trying to formate a list of cells to display in the
dd/mmm/yy format when you type a date in the 9/6/04 format, I have
tried applying this as a formula and also right clicking and changing
the format date to dd/mmm/yy and it wont change. In the greyed bar it
just leaves it as what ever i have typed, and if you click on different
formats in the date list it still stays the same in this bar. Any ideas?

« IF or Lookup | Not listing more than a range of rows »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel wont recognise date format	Fendi Baba	Microsoft Excel Discussion	4	17th May 2007 10:22 AM
Date format from excel to CVS file wont. Change in CVS wont stay.	=?Utf-8?B?RmlzaCcncyBNZXJtYWlk?=	Microsoft Excel Worksheet Functions	1	14th Oct 2006 12:28 AM
Date Wont Change in Excel??!	laurahhh@gmail.com	Microsoft Excel Worksheet Functions	2	18th Sep 2006 07:46 AM
trouble going back to earlier date calendarb wont change		Windows XP General	0	11th Jul 2003 06:04 PM
trouble going back to earlier date calendarb wont change		Windows XP General	0	11th Jul 2003 06:04 PM