• Home
  • Training Books
  • Subscribe to Our Email Newsletter
  • About
    • Contributors
    • Feedback
    • Contact
    • Privacy policy
    • Cookie Policy

CADnotes

CAD Tutorials and Best Practices for professionals and students

  • Featured
  • AutoCAD
    • AutoLISP
  • Revit
    • Revit Architecture Basic
    • Revit MEP Basic Tutorial
  • Inventor
  • MicroStation
    • MicroStation Basic Tutorial
  • CADnotes on YouTube
You are here: Home / AutoCAD / Why I can’t Use Formula in xls Created by Data Extraction?

Why I can’t Use Formula in xls Created by Data Extraction?

July 16, 2009 by Edwin Prakoso 3 Comments

data extraction table

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:

  1. Select all the cells contain your data in excel, click copy on the ribbon (or press [ctrl] + C) to copy them to clipboard.
  2. Open notepad, paste them here.
  3. Select all (you can press [ctrl] + A) then copy this value to clipboard.
  4. Paste them back in excel.

Now your formula should works ;)

About Edwin Prakoso

I work as a Solution Consultant in Datech Solutions, Tech Data Indonesia. I've been using AutoCAD since R14 and Revit since Revit Building 9. I occasionally write for AUGIWorld magazine and I am also active in Autodesk discussion forum. I'm a member of Autodesk Expert Elite, an appreciation for individuals who give contributions to the Autodesk community.
Connect with me on twitter or LinkedIn. If you want to have my new articles sent to your email inbox, you can subscribe to the newsletter.

Filed Under: AutoCAD

0 0 votes
Article Rating
Subscribe
Login
Notify of
guest

guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

3 Comments
Inline Feedbacks
View all comments
Nicolas
Nicolas
9 years ago

you can also select the cells marked with the green tip and, when the exclamation mark appears besides the selection, right/click on it, and select “Convert to number”

0
Reply
Ed
Ed
11 years ago

i'm afraid it doesn't work :(

0
Reply
Ewen
Ewen
14 years ago

You can also use "Paste Special" to get around this in Excel.1. Copy a cell with "1" in it. It can be formatted as text – that doesn't matter.2. Highlight all the cells with numbers in them you with to treat as numbers.3. Edit -> Paste Special -> Multiply.4. Rejoice!

0
Reply
wpdiscuz   wpDiscuz
Join Our Free Email Newsletter
  Thank you for Signing Up
Please correct the marked field(s) below.
1,true,6,Contact Email,2 1,false,1,First Name,2 1,false,1,Last Name,2

Featured

What’s new in AutoCAD: Block and References

AutoCAD new features roundup in several last versions. In this post we will see what’s new in blocks and references.

Recent Articles

  • Revit 2024.1 Update is Released
  • What’s New in Revit 2024: Bending Detail
  • What’s New in Revit 2024: The Dark Theme

Advertisement

New on CADnotes

  • Revit 2024.1 Update is Released
  • What’s New in Revit 2024: Bending Detail
  • What’s New in Revit 2024: The Dark Theme
  • Autodesk Build: Using Assets for Progress Tracking
  • My Home on the ACC Unified Platform

Meet the Authors

avatar for
avatar for
avatar for
avatar for
avatar for
avatar for

Get Connected

CADnotes on FacebookCADnotes on InstagramCADnotes on TwitterCADnotes on YouTube

© 2009 – 2023 CADnotes · Feedback · Privacy Policy · Become an affiliate

wpDiscuz