Write To Excel - but numbers as text

Packages
1

Hi All!

I have this issue. When I to write room numbers to excel, I would like to save it as text. Some room numbers is named like “007” and then comes out as “7”. How can I apply this function - to write as text, so the two zeros stays in the room number? Thanks!

ExportAsText
ExportAsText.jpg1421×707 225 KB

 

2

string from object should do it

 

Andrew

3

Hi Anders,

You need to make some changes in excel.

Untitled
Untitled1.png1699×709 193 KB

4

Hey Kulkul thanks. If any know how to let Dynamo do the job, please let me know.

5

If you add an apostrophe to the front of the room numbers before pushing it into Excel it will force it to treat it as text instead of a number. When Reading the data back from the Excel file it won’t include the apostrophe.

excel_text_numbers
excel_text_numbers.png1478×684 198 KB

6

hey timothy, that is definitely a good one :wink:

didn’t know that so far

thanks for sharing