View previous topic :: View next topic |
Author |
Message |
mdgraves
Joined: 04 Nov 2010 Posts: 1
|
Posted: Thu Nov 04, 2010 11:42 am Post subject: Export to EXCEL - Dates |
|
|
I recently downloaded the SmartGenealogy program, and attempted the export to MS EXCEL. I love that feature. BUT, I found one quick issue that could be CRITICAL. The date format used in export has the values in EXCEL as mm/dd/yy. Excel by default thinks these are 19xx dates, as when I reformat to mm/dd/yyyy they are at 19xx year.
Any ideas on getting the correct dates exported to EXCEL? |
|
Back to top |
|
![](templates/subBlack/images/spacer.gif) |
ale Site Admin
![](http://alainlecomte.free.fr/phpBB2/images/avatars/gallery/ale/001.jpg)
Joined: 12 Apr 2005 Posts: 499 Location: Versailles, France
|
Posted: Sat Nov 06, 2010 10:56 pm Post subject: |
|
|
Dates stored in SmartGenealogy will be exported in the Excel file as text : They will be exactly the text that you typed-in in the database.
For instance, if a birth date as been saved as "31/03/2010", it will be stored in the Excel file as the text "31/03/2010".
Now, if you want to change the way it looks like in you Excel worksheet, you just have to do as follow (have a look to the picture below) :
- Select the date column (for instance "Birth-date") and change its type from Standard to Date
- Change the format of the date for instance from DD/MM/YYYY to YYYY-MM-DD
This does not change the data themself, but only how it looks like in the "Birth-date" column.
1 = Cell with original text format
2 = Cell formated as a Date DD-MM-YYYY
3 = Cell formated as a Date YYYY-MM-DD
![](http://alainlecomte.free.fr/autres/SmartGen_DatesExcel.jpg) |
|
Back to top |
|
![](templates/subBlack/images/spacer.gif) |
|