Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is there a way to format yyyy/mm/dd before 1900
I have a database with dates ranging from 1839 to the present. I tried to
format date as mm/dd/yyyy and everything works fine. When I needed to change the format to yyyy/mm/dd, only the dates after 1900 were formatted. Is there a way to do this without retyping every cell in the correct format. I have over 28,000 records |
#2
|
|||
|
|||
Hi Cousin_Geo
See John's page about this http://j-walk.com/ss/excel/usertips/tip028.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Cousin_Geo" wrote in message ... I have a database with dates ranging from 1839 to the present. I tried to format date as mm/dd/yyyy and everything works fine. When I needed to change the format to yyyy/mm/dd, only the dates after 1900 were formatted. Is there a way to do this without retyping every cell in the correct format. I have over 28,000 records |
#3
|
|||
|
|||
Hi Geo
Excel can't work natively with dates before 1900 but there is an add-in written on the site www.j-walk.com that allows you to go back a few hundred more years. Alternatively you could break the date up by using left, mid and right if they are all the same witdth OR if there is a delimiter i.e. a / then you could use the text to columns feature and then concatenate the columns back in the order that you want them Best Regards Paul -----Original Message----- I have a database with dates ranging from 1839 to the present. I tried to format date as mm/dd/yyyy and everything works fine. When I needed to change the format to yyyy/mm/dd, only the dates after 1900 were formatted. Is there a way to do this without retyping every cell in the correct format. I have over 28,000 records . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i change numbers in text format to number format? | New Users to Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Help Q: Entering 7 p time format, does not convert to 19:00 | Excel Discussion (Misc queries) | |||
Copying a conditional format | Excel Worksheet Functions | |||
When I select "format cells", the format dialog box does not disp. | Excel Worksheet Functions |