Excel Help
Hmm, since I sent my puter to get tidied up, I've had nothing but problems. I now have problems in Excel, I never have problems in excel, so please help if you can.
Basically, when I type in a date eg 02/12/07 in the dd/mm/yy format, it immediately converts to 12/02/07. But, when you click on the cell, the line at the top still reads it as the original 02/12/07.
In addition to this, when I drag and copy down, it adds to the year rather than the date.
On top of that, when you try to add 7 days onto it (=A1+7) which works in an old spreadsheet, it just comes up with the #value error.
This should be very simple so I don't understand what I'm doing wrong.
Any help?
Edit: the spreadsheet is set up to be English (UK) rather than English (US) and the date format is set as I want it, dd/mm/yy, so all that side of things is already set up as it normally is, hence why I'm confused.
Ta
Basically, when I type in a date eg 02/12/07 in the dd/mm/yy format, it immediately converts to 12/02/07. But, when you click on the cell, the line at the top still reads it as the original 02/12/07.
In addition to this, when I drag and copy down, it adds to the year rather than the date.
On top of that, when you try to add 7 days onto it (=A1+7) which works in an old spreadsheet, it just comes up with the #value error.
This should be very simple so I don't understand what I'm doing wrong.
Any help?
Edit: the spreadsheet is set up to be English (UK) rather than English (US) and the date format is set as I want it, dd/mm/yy, so all that side of things is already set up as it normally is, hence why I'm confused.
Ta