I am saving a cognos imrpomtu report in excel but not formatted up by report
writer.

It is giving me trouble in date fileds maybe.

I need to understand that excel is reading date right

I think the filed is orginally a date and time but not sure.

Do I use a formula to fix or secire this date or do I just format as date in
excel.

If I format date and time I get the time as 12am un all fields so i assume
from this no time was exported

wow- thanks