Dates on Works spreadsheet

  capnsofa 23:24 15 Oct 03
Locked

I have entered a column of dates showing just the day and month e.g. 15/10 (15 October). I wish to include the year (last two numbers) - is there any way this can be done without having to enter each date separately ? I tried using 'Format - Numbers - Date' entering the correct year in the first cell and then dragging the mouse over the required cells, but then I get '03' as the year regardless of what I initially entered.

  smegs 00:20 16 Oct 03

Could tell us the software your using? I'm using Xp Office, and that does it how you want it done.

  capnsofa 09:56 16 Oct 03

My system is Windows 98 - using Works Suite 2000 for setting up the spreadsheet.

  seedie 10:55 16 Oct 03

In your example did you just enter 15/10 or did you enter 15/10/03 and format DD/MM.

If you did not put the year in you may have to do it by hand in all cells



CD

  Cesar 12:00 16 Oct 03

I have just run a test in Excel I entered the dates as: 15/10/03 and 20/10/03 selected the cells and chose a date format and the result was 15 October 2003 and 20 October 2003. You must select the cells before formatting.

This thread is now locked and can not be replied to.

What is Amazon Go and will it come to the UK? The store without checkouts or queues

1995-2015: How technology has changed the world in 20 years

Hands-on with the Star Wars fighting drones you can fly yourself

iPhone 9 and beyond: 32 amazing future smartphone developments - graphene, supercapacitor…