Export Grid to Excel - text in stead of numbers or date

W

Willy_comp

When using 'export grid to excel' and the columns contains e.g. a "Start
Date" and "Work" (expressed in hours), then the data is stored as text in
Excel.

The date-text is transformed to a date, if you click in the cell and press
"Enter".
Work is stored as e.g. "7h" and will never become a numeric value. (=>
difficult to make calculations)

Is there a way to avoid this behaviour ?

regards,
Willy
 
N

Nicky D.

Willy,
I don't know of a way to avoid the behavior, but have experienced similar
behavior in Excel.
My solution is to highlight the columns that contain 7h (for example), and
replace all 'h' with '' (h with blank/null).
Rather than hitting enter on each cell that contains a date, could you try
formatting that column? I don't recall having to modify date fields - sorry
I can't offer any additional help.
(This assumes your data is columns)
Nicky D.
 
Top