please disregard this question terrible misunderstanding
thanks for time
"Andy" wrote:
Hi
What does the date field show in Excel, when formatted as General?
Andy.
"Todd F." wrote in message
...
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
|