# Can't Write Numbers from Excel to Text Parameter **URL:** \ **Category:** Revit\ **Tags:** revit, excel\ **Created:** [October 20, 2017, 5:12pm UTC](https://forum.dynamobim.com/t/cant-write-numbers-from-excel-to-text-parameter/15793 "2017-10-20T17:12:12Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Chad\_Clary](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/chad_clary/32/10510_2.png) [@Chad\_Clary](https://forum.dynamobim.com/u/Chad_Clary)\ **Post date:** [October 20, 2017, 5:12pm UTC](https://forum.dynamobim.com/t/cant-write-numbers-from-excel-to-text-parameter/15793/1 "2017-10-20T17:12:12Z")
I’ve been beating my head against the wall for a while now and am stumped. I’m trying to write parameters from Excel to my families. The parameter is a text parameter, the values in Excel are a mix of symbols (–) and numbers. So far I’ve tried a variety of cell formatting options in Excel, several different Set.Parameter nodes, String From Array, and String From Object. StringFromArray worked but the result wasn’t quite what I expected (or need) and String From Object converts everything but the numerical values end up as decimals; instead of 15, 16, 17 I get 15.000, 16.000, 17.000 etc. ![ImportFromExcel](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/f/9/f9b6217bc57dd6462d5cd3fb8ac385134763662a.png) Graph is nothing fancy. Dynamo is reading everything correctly, I just can’t get it to actually write numerals (symbols & text work fine)… Is there a trick to get something into a text parameter if it isn’t an alphabet character or symbol? ---
**Author:** ![jacob.small](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jacob.small/32/161030_2.png) [@jacob.small](https://forum.dynamobim.com/u/jacob.small)\ **Post date:** [October 20, 2017, 6:03pm UTC](https://forum.dynamobim.com/t/cant-write-numbers-from-excel-to-text-parameter/15793/2 "2017-10-20T18:03:47Z")
String from Object is the solution. You need to then use a string.replace node to swap the “.0000000” with “”. ---
**Author:** ![Chad\_Clary](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/chad_clary/32/10510_2.png) [@Chad\_Clary](https://forum.dynamobim.com/u/Chad_Clary)\ **Post date:** [October 20, 2017, 6:18pm UTC](https://forum.dynamobim.com/t/cant-write-numbers-from-excel-to-text-parameter/15793/3 "2017-10-20T18:18:33Z")
Thanks. 🍻 ---
**Author:** ![Yna\_Db](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/yna_db/32/30641_2.png) [@Yna\_Db](https://forum.dynamobim.com/u/Yna_Db)\ **Post date:** [October 20, 2017, 8:31pm UTC](https://forum.dynamobim.com/t/cant-write-numbers-from-excel-to-text-parameter/15793/4 "2017-10-20T20:31:28Z")
Ses this optionally: > [@Springs.Number.ToString possibly not working in the current package](https://forum.dynamobim.com/t/springs-number-tostring-possibly-not-working-in-the-current-package/15039): > > A very useful node! I don’t know why the “String from Object” node adds lots of Zeros after the decimal. This one doesn’t, it just converts however the number looks to an identical string. However, I am not sure that it is working in the latest version. I built a script using version 110.2.0 and it worked great. When I wanted other users to execute the script, I had them install the various required packages, but it didn’t work. I narrowed it down to this node in the current version of Spri… ---
**Author:** ![Rabindra\_Adhikari](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/rabindra_adhikari/32/31788_2.png) [@Rabindra\_Adhikari](https://forum.dynamobim.com/u/Rabindra_Adhikari)\ **Post date:** [October 20, 2023, 3:09am UTC](https://forum.dynamobim.com/t/cant-write-numbers-from-excel-to-text-parameter/15793/5 "2023-10-20T03:09:07Z")
If possible, the “Data.ImportExcel” should respect the cell formatting in Excel. Any cell value that is computed value in Excel is converted to Numbers automagically. I recommend we should let Excel maintain the cell formatting and and “data. ImportExcel” should respect the data type while importing. This would eliminate an extra step every time. @jacob.small Please see if you can make this happen. ---
**Author:** ![jacob.small](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jacob.small/32/161030_2.png) [@jacob.small](https://forum.dynamobim.com/u/jacob.small)\ **Post date:** [October 20, 2023, 6:26am UTC](https://forum.dynamobim.com/t/cant-write-numbers-from-excel-to-text-parameter/15793/6 "2023-10-20T06:26:03Z")
> [@Rabindra\_Adhikari](#): > > If possible, the “Data.ImportExcel” should respect the cell formatting in Excel A quick note: This node should be replaced with the open XML import excel node, as the new node is multiple orders of magnitude more stable. It does appear that this is possible after reviewing this link: [https://learn.microsoft.com/en-us/office/open-xml/how-to-retrieve-the-values-of-cells-in-a-spreadsheet](https://learn.microsoft.com/en-us/office/open-xml/how-to-retrieve-the-values-of-cells-in-a-spreadsheet) However it would need a good amount of testing - in particular in regards to formula results… in any case, best to submit a feature request via the Dynamo wish list here: [GitHub - DynamoDS/DynamoWishlist: This is a repository for all wishlist items for Dynamo Core](https://github.com/DynamoDS/DynamoWishlist) Or to the roadmap here: [Roadmap - Dynamo BIM](https://dynamobim.org/roadmap/)