Have you used AutoCAD data extraction? This is a very handy tool to create a report about any data from your AutoCAD drawing. Some of my colleague choose to extract the drawings information to excel instead of directly to his drawing. They want to modify the values further, and using excel is easier (and faster).
But here comes the problem: when he tried to sum any column, he can’t get excel to calculate the values. What’s wrong?
Apparently, AutoCAD export all the data to text strings, not numbers. That’s why you can’t get them calculated.
To fix this is easy:
- Select all the cells contain your data in excel, click copy on the ribbon (or press [ctrl] + C) to copy them to clipboard.
- Open notepad, paste them here.
- Select all (you can press [ctrl] + A) then copy this value to clipboard.
- Paste them back in excel.
Now your formula should works ;)