LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Terry Bennett
 
Posts: n/a
Default Entering historic dates

Sorry if this is a very basic query ...

I have to enter a large number of dates into a spreadsheet during the period
1972 - 1976. Obviously, if you just enter a date into Excel using the
keystrokes 28/6, it assumes that you are referring to the current year. As
I will be entering the data in chronological order, how can I avoid having
to type 28/6/1973, 1/7/1973, 5/7/1973, etc all the time? Is there a way I
can get Excel to treat all the dates as being in a particular past year ...
or can I enter them all as this year and then change them in blocks somehow?

Any advice appreciated!


 
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
entering items on specific dates of year Puzzled Excel Discussion (Misc queries) 0 March 11th 06 03:32 PM
Entering DATEs in EXCEL should not require use of "/" slashes. Receptionist Excel Discussion (Misc queries) 1 September 12th 05 05:11 PM
Entering dates in Excel 2002 DickG Excel Discussion (Misc queries) 3 January 9th 05 02:56 PM
entering and updating dates on a spreadsheet slewis3 Excel Worksheet Functions 2 December 24th 04 01:06 AM
Entering dates QUICKLY DOMINIC JOSLIN Excel Discussion (Misc queries) 4 December 10th 04 09:46 AM


All times are GMT +1. The time now is 01:19 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"