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: 3
Default Excel date formatting

Hi~

I am having trouble with excel changing the format of how I am wishing to
enter the dates. I am entering the dates one of two ways: The first is
Season/year (ie. Fall 1999), the second is Month/year (ie. March 1999).
Excel doesn't change the season/year on me, but it does change the month/year
date into a month/day/year format, and one that is totally off. It gives me
something like 06/01/1905 when I type in March 1999. Any suggestions on how I
might remedy this problem and get Excel to not change what and how I have
enter the dates would be most appreciated.

Thanks,
Arron
 
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
Date formatting in Excel Ricky4 Excel Discussion (Misc queries) 2 May 8th 08 04:31 PM
Date Formatting in Excel Urgent KICI Excel Discussion (Misc queries) 1 April 21st 08 10:23 PM
date formatting in excel kwood525 Excel Worksheet Functions 5 August 31st 07 07:18 PM
Formatting the Date in Excel JD Excel Discussion (Misc queries) 3 July 14th 05 11:07 PM
Date formatting in Excel vanness95678 Excel Discussion (Misc queries) 1 January 10th 05 11:24 PM


All times are GMT +1. The time now is 03:57 AM.

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

About Us

"It's about Microsoft Excel"