# Combining Room Schedule Parameters for Excel Export

**URL:** https://forum.dynamobim.com/t/combining-room-schedule-parameters-for-excel-export/5822
**Category:** Uncategorized
**Created:** [August 25, 2016, 10:28am UTC](https://forum.dynamobim.com/t/combining-room-schedule-parameters-for-excel-export/5822 "2016-08-25T10:28:41Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![david.m.hopkins](https://avatars.discourse-cdn.com/v4/letter/d/a4c791/32.png) [@david.m.hopkins](https://forum.dynamobim.com/u/david.m.hopkins)
#### Post date: [August 25, 2016, 10:28am UTC](https://forum.dynamobim.com/t/combining-room-schedule-parameters-for-excel-export/5822/1 "2016-08-25T10:28:41Z")

</div>

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.

 ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/2X/d/d423fd5a7b901ac248b9e04562c733fab6bf1263.png)

---

<div class="post-metadata">

### Author: ![Kulkul](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kulkul/32/49801_2.png) [@Kulkul](https://forum.dynamobim.com/u/Kulkul)
#### Post date: [August 25, 2016, 10:54am UTC](https://forum.dynamobim.com/t/combining-room-schedule-parameters-for-excel-export/5822/2 "2016-08-25T10:54:39Z")

</div>

> [@david.m.hopkins](#):
>
> 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.

Hi David,  
Could you show values of your room numbers?

---

<div class="post-metadata">

### Author: ![david.m.hopkins](https://avatars.discourse-cdn.com/v4/letter/d/a4c791/32.png) [@david.m.hopkins](https://forum.dynamobim.com/u/david.m.hopkins)
#### Post date: [August 25, 2016, 11:18am UTC](https://forum.dynamobim.com/t/combining-room-schedule-parameters-for-excel-export/5822/3 "2016-08-25T11:18:15Z")

</div>

Hi Kulkul

The problem ones for this building are conventioned with floor level / number. Did you mean for me to upload a list?

 ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/2X/b/b8e426f374c5845b15539233d99f4f3b35bd650e.png) Hopefully this illustrates the issue.

Best,

Chris

---

<div class="post-metadata">

### Author: ![Kulkul](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kulkul/32/49801_2.png) [@Kulkul](https://forum.dynamobim.com/u/Kulkul)
#### Post date: [August 25, 2016, 12:52pm UTC](https://forum.dynamobim.com/t/combining-room-schedule-parameters-for-excel-export/5822/4 "2016-08-25T12:52:09Z")

</div>

Add "0 " before feeding data.

 ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/2X/3/324b68201d2702e1f30c71dac9ed923c90d398d7.png)