I have a problem whereby room numbers are exporting to Excel in date format due to a / being in the numbering convention. Eg 4/11. I’ve tried exporting as csv instead but this strangely doesn’t allow you to prevent the numbers being converted to dates. I think the best route would be for me to combine floor level and room number as a field however I’m struggling to do this. Any suggestions how I can do this would be appreciated. The Dynamo script without this improvement is attached.
