Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formatting dates prior to 1900
I need to enter dates in dd/mm/yyyy format prior to 1900 like 14/02/1834.
Can this be done? Thanks -- Pete |
#2
|
|||
|
|||
"Pete the Mag" wrote in message ... I need to enter dates in dd/mm/yyyy format prior to 1900 like 14/02/1834. Can this be done? Thanks -- Pete Use an apostrophe as the first character, i.e. '14/02/1834 the postrophe won't appear and Excel will treat what follows as text. /Fredrik |
#3
|
|||
|
|||
Thanks but,
I should have correctly posed the question as: I need to enter dates in dd/mm/yyyy format prior to 1900 like 14/02/1834, and be able to sort them into chronological order. Can this be done? "Fredrik Wahlgren" wrote: "Pete the Mag" wrote in message ... I need to enter dates in dd/mm/yyyy format prior to 1900 like 14/02/1834. Can this be done? Thanks -- Pete Use an apostrophe as the first character, i.e. '14/02/1834 the postrophe won't appear and Excel will treat what follows as text. /Fredrik |
#4
|
|||
|
|||
Excel doesn't support dates prior to 1900. John Walkenbach has
and extended date add-in that does, which you can find somewhere at www.j-walk.com/ss -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Pete the Mag" wrote in message ... Thanks but, I should have correctly posed the question as: I need to enter dates in dd/mm/yyyy format prior to 1900 like 14/02/1834, and be able to sort them into chronological order. Can this be done? "Fredrik Wahlgren" wrote: "Pete the Mag" wrote in message ... I need to enter dates in dd/mm/yyyy format prior to 1900 like 14/02/1834. Can this be done? Thanks -- Pete Use an apostrophe as the first character, i.e. '14/02/1834 the postrophe won't appear and Excel will treat what follows as text. /Fredrik |
#5
|
|||
|
|||
"Pete the Mag" wrote in message ... Thanks but, I should have correctly posed the question as: I need to enter dates in dd/mm/yyyy format prior to 1900 like 14/02/1834, and be able to sort them into chronological order. Can this be done? Yes. Let's say you have entered '14/02/1834 in A1 and downwards. Copy the column and paste the values to column B. Now, select column B and use Data|Text to columns. The wizard is easy to understand. The dates will be split to thre columns. Select columns A to D and select Data|Sort. Sort first on D, then on C and then on B. When you're done, you an delete columns B to D. /Fredrik |
#6
|
|||
|
|||
Yes many thanks Fredrik. That will do it fine. Pete
Thanks to all respondents. "Fredrik Wahlgren" wrote: "Pete the Mag" wrote in message ... Thanks but, I should have correctly posed the question as: I need to enter dates in dd/mm/yyyy format prior to 1900 like 14/02/1834, and be able to sort them into chronological order. Can this be done? Yes. Let's say you have entered '14/02/1834 in A1 and downwards. Copy the column and paste the values to column B. Now, select column B and use Data|Text to columns. The wizard is easy to understand. The dates will be split to thre columns. Select columns A to D and select Data|Sort. Sort first on D, then on C and then on B. When you're done, you an delete columns B to D. /Fredrik |
#7
|
|||
|
|||
Pete
Download John Walkenbach's Extended Dates add-in. You can work with dates prior to 1900. http://www.j-walk.com/ss/excel/usertips/tip028.htm Gord Dibben Excel MVP On Wed, 30 Mar 2005 11:49:05 -0800, Pete the Mag wrote: I need to enter dates in dd/mm/yyyy format prior to 1900 like 14/02/1834. Can this be done? Thanks |
#8
|
|||
|
|||
Thanks Gord. This will be useful. Pete
"Gord Dibben" wrote: Pete Download John Walkenbach's Extended Dates add-in. You can work with dates prior to 1900. http://www.j-walk.com/ss/excel/usertips/tip028.htm Gord Dibben Excel MVP On Wed, 30 Mar 2005 11:49:05 -0800, Pete the Mag wrote: I need to enter dates in dd/mm/yyyy format prior to 1900 like 14/02/1834. Can this be done? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
graph dates revert to 1900 | Charts and Charting in Excel | |||
conditional formatting overdue dates | Excel Discussion (Misc queries) | |||
Formatting dates in the future | Excel Worksheet Functions | |||
Need to sort dates before 1900 in proper order | Excel Discussion (Misc queries) | |||
Conditional Formatting Dates | Excel Worksheet Functions |