https://www.ptcusercommunity.com/t5/Mathcad/READEXCLE-function-brings-number-in-as-not-a-scaler/m-p/719457#M195044 <P>Hi all I am using the readexcel function in mathcad prime 6.0.0.0 and to even read in a number it comes in as not a scaler. is there a set format in excel that i am missing as you can see the number below comes in in brackets [1] as an example. I have tried both .xlsx and .xlsm file types both give me the same.&nbsp;</P> <P>&nbsp;</P> <P>note: the if function below is just an example to show I cant use the data brought in because of the [1] (brackets).&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BG_9641770_0-1616059318173.png" style="width: 400px;"><img src="https://www.ptcusercommunity.com/t5/image/serverpage/image-id/39040iE9394C4B79BF7340/image-size/medium?v=v2&amp;px=400" role="button" title="BG_9641770_0-1616059318173.png" alt="BG_9641770_0-1616059318173.png" /></span></P> <P>&nbsp;</P> <P>Thanks</P> <P>Ben&nbsp;</P> <P>&nbsp;</P> Thu, 18 Mar 2021 09:27:27 GMT BG_9641770 2021-03-18T09:27:27Z https://www.ptcusercommunity.com/t5/Mathcad/READEXCLE-function-brings-number-in-as-not-a-scaler/m-p/719457#M195044 <P>Hi all I am using the readexcel function in mathcad prime 6.0.0.0 and to even read in a number it comes in as not a scaler. is there a set format in excel that i am missing as you can see the number below comes in in brackets [1] as an example. I have tried both .xlsx and .xlsm file types both give me the same.&nbsp;</P> <P>&nbsp;</P> <P>note: the if function below is just an example to show I cant use the data brought in because of the [1] (brackets).&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BG_9641770_0-1616059318173.png" style="width: 400px;"><img src="https://www.ptcusercommunity.com/t5/image/serverpage/image-id/39040iE9394C4B79BF7340/image-size/medium?v=v2&amp;px=400" role="button" title="BG_9641770_0-1616059318173.png" alt="BG_9641770_0-1616059318173.png" /></span></P> <P>&nbsp;</P> <P>Thanks</P> <P>Ben&nbsp;</P> <P>&nbsp;</P> Thu, 18 Mar 2021 09:27:27 GMT https://www.ptcusercommunity.com/t5/Mathcad/READEXCLE-function-brings-number-in-as-not-a-scaler/m-p/719457#M195044 BG_9641770 2021-03-18T09:27:27Z https://www.ptcusercommunity.com/t5/Mathcad/READEXCLE-function-brings-number-in-as-not-a-scaler/m-p/719806#M195046 <P>What's wrong with this answer?</P> <P><A href="https://community.ptc.com/t5/PTC-Mathcad/READEXCEL/m-p/719459#M194995" target="_blank">https://community.ptc.com/t5/PTC-Mathcad/READEXCEL/m-p/719459#M194995</A> </P> <P>&nbsp;</P> <P>Luc</P> Fri, 19 Mar 2021 12:59:15 GMT https://www.ptcusercommunity.com/t5/Mathcad/READEXCLE-function-brings-number-in-as-not-a-scaler/m-p/719806#M195046 LucMeekes 2021-03-19T12:59:15Z