Exporting as CSV with linked records as numbers are messed up

[espressivo]

Hi! You can see from the screenshots that my export as CSV does some crazy stuff to my records. Ideas on how to fix?

[Kamille_Parks]

Looks like Excel is converting that column to a number which is normal behavior for Excel.

Try using a Rollup field in your export that does something like this for the aggregation formula:
'#' & ARRAYJOIN(values, ', #')

That way you get “#10547, #10544, #10542…” instead, and Excel won’t do anything weird to that field.