I have a query in MSAccess which I export to Excel as a formatted spreadsheet.

For some reason, it is truncating the data when it goes into excel, yet when
I export the same data without saving it as formatted, this does not happen.

any ideas please?
thanks