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.
Could you show values of your room numbers?
The problem ones for this building are conventioned with floor level / number. Did you mean for me to upload a list?