Import errors reformatting text as numbers/dates/times

Import errors reformatting text as numbers/dates/times

Hi,

Hope you can help. Recently when importing an XLS spreadsheet into Reports, i have noticed that text columns that START with a number are interpreted as numbers/dates/times by Reports. e.g. the original text "3AM" results in 03:00:00 appearing in the column even though both the original spreadsheet AND the Zoho import settings are for the column to regrad the content as text. This has only started happening recently; previously the data was imported OK.

Many thanks

D