I am exporting into Excel from the electronic medical record system,
AllScripts Professional EHR. There are 2 columns of dates which ultimately I
need to subtract. One column of dates comes across just fine, it's obviously
a date column. The other column of dates, when you click on a cell, NOTHING
shows up in the white bar below the ribbon, however, there are dates that are
left justified in the column, plain as day. My challenge is to turn these
mysterious cells into dates so I can perform the subtraction. One more note,
the column in question (along with the text column before it) does not show
up on the screen after export unless I insert a column and then the text and
"date" columns pop up on the screen. AllScripts says there are "special
characters" there and has no real ideas for me. Thanks! Note: Version is
2007