How to remove #N/A?
Show older comments
I would like to replace all of the elements #N/A of the vector with zeros
#N/A
1336.94
#N/A
#N/A
#N/A
#N/A
1271.44
1336.94
1967.27
3190.22
3207.76
3 Comments
Jan
on 19 May 2021
Where do you see this output? What are the values in Matlab?
Chiara Scarpellini
on 19 May 2021
per isakson
on 19 May 2021
In Excel #N/A stands for "null (#N/A) values".
When (R2018b) I import numerical data that contains #N/A it is converted to NaN in Matlab. How did you import from Excel ?
Answers (0)
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!