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

Revit
1

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

2

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.

1 Like
3

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

2 Likes
4

Hi Guys,

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

5

Hey guys,

Sorry I didn’t return comment on this sooner. You were both right changing the value to a string helped.

Thanks

Brock