When exporting Room name from model to excel some leading 0's are removed

Hi Guys,

I’m hoping someone can help me out here. This seems like a small issue but to a new user i am finding it difficult and any help would be appreciated.

I am having a problem where when room numbers are getting exported somewhere between the export and excel some of my room numbers for eg. 90.220 ends up as 90.22 in excel. I have had a look online and haven’t found a solution.

Thanks in advance

Brock

Try appending a ‘ before each value In Dynamo before you write to excel. This will force excel to treat the data as a string instead of a double.

Hi @bwilkeA77N6,

please convert the values to string first, the values are interpreted as floating values by excel that is why the zeroes are omitted.

-biboy

1 Like

Hi Guys,

Thank you for your help.
I will have a go at this and let you know how i go :+1: