Try to save as CSV first and that import it.

>Trying to append from xls into cursor. There is a custom cell format
>h:mm AM/PM imports as a date struct. I need to go into the XLS manually
>and remove the format. Make it like "general"
>
>No idea there either! Tried copy & Paste Special?