Excel lecturer David Ringstrom continues to share his productivity tips with the trans-Atlantic Excel user community.
Excel dates
This article collects together ExcelZone tips and tricks for dealing with the problems that can occur when working with dates in Excel.
A new series of articles offering tips and tricks to conquer common Excel problems starts with time formats and calculations.
i have had a 'database' created in excel ie rows + columns of data and lots of it !
5
have an excel sheet containing a summary of a lot of word file, tables data which has been cut and pasted into excel
3
I have a column which I believe have dates in text. I would like to convert them in to proper date, ie DD-MM-YY.
For example: How do I convert 6th October in to 06-10-10?
11
I've just spent 3 hours manipulating several hundred lines of accounting data copied from a client's Excel spreadsheet and then spotted that all the transactions I was playing with were dated 2005
5
Hello all,
I am wondering if someone can help me with an excel problem. I am trying to draw up a spreadhseet for revenue received that is split over a period for accrual purposes.
7
Does any one know a quick method to resolve the issue of a spreadsheet with dates entered as text
e.g "10.12.2008"
7
