Excel doesn't recognize dates prior to 1900 so it will leave those
alone. Dates starting with 1900 are converted to a number so you can do
'arithmetic' on them. Thus full dates are converted and partial dates
are not. You must have the date formatting in excel set up to show
m/d/. Those tha
I won't be able to try it until later tonight. But I can tell you that it
appears to only affect full dates after 1 Dec 1900. Dates in the 20th and 21st
centuries seem to be affected if the full date has been entered. Any dates
prior to that are captured correctly in the CSV file and therefor
On 28/02/2012 17:28, brenze...@roadrunner.com wrote:
> I'm hoping that someone can tell me why some of the dates in Legacy
> are coming into the CSV file in format "dd-mmm-yy" (1-Sep-13) while
> others are "dd mmm " (1 Sep 1913). It is from there that they
> are displayed incorrectly in Excel.
I'm hoping that someone can tell me why some of the dates in Legacy are coming
into the CSV file in format "dd-mmm-yy" (1-Sep-13) while others are "dd mmm
" (1 Sep 1913). It is from there that they are displayed incorrectly in
Excel.
All of the dates in Legacy look to be formatted the same
On 2012/02/28 13:49, M. Brenzel wrote:
> I have Excel 2007. Re-formatting the entire column is not an option, as
> dates that are year only (for example, 1965) get messed up.
Legacy dates are not always 'true' dates. It would be better if your
spreadsheets treated Legacy dates as simple, plain t
Subject: Re: [LegacyUG] Dates in CSV file
What version of Excel are you using? The newest versions will alow you to
format dates with 4 digits for the year. Highlight or select the entire
column, go to Format cells, select the number tab, select Date and then select
the specific format you want
February 2012 02:14
To: LegacyUserGroup@LegacyUsers.com
Subject: [LegacyUG] Dates in CSV file
I have created a CSV file from the Name List containing Surname/Given Name,
Living Indicator, Birth Date, and Death Date. When I look at the file in
Notepad, the dates look good. But when I open it in
ruary 27, 2012 6:14 PM
Subject: [LegacyUG] Dates in CSV file
I have created a CSV file from the Name List containing Surname/Given Name,
Living Indicator, Birth Date, and Death Date. When I look at the file in
Notepad, the dates look good. But when I open it in Excel, some of the
dates are form
What version of Excel are you using? The newest versions will alow you to
format dates with 4 digits for the year. Highlight or select the entire
column, go to Format cells, select the number tab, select Date and then select
the specific format you want. I hope this helps. Jerry
"M. Brenzel
I have created a CSV file from the Name List containing Surname/Given Name,
Living Indicator, Birth Date, and Death Date. When I look at the file in
Notepad, the dates look good. But when I open it in Excel, some of the
dates are formatted differently than most of the others.
For example, the da
10 matches
Mail list logo