cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can Bookmark boards, posts or articles that you'd like to access again easily! X

READEXCLE function, brings number in as not a scaler

BG_9641770
12-Amethyst

READEXCLE function, brings number in as not a scaler

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. 

 

note: the if function below is just an example to show I cant use the data brought in because of the [1] (brackets). 

 

BG_9641770_0-1616059318173.png

 

Thanks

Ben 

 

1 REPLY 1
LucMeekes
23-Emerald III
(To:BG_9641770)

Announcements

Top Tags