| Author |
Message |
Larry
Guest
|
 Posted:
Tue Aug 30, 2005 12:10 am Post subject:
Attribute Extraction to Excel |
|
|
When I open up an excel sheet that has been extracted from AutoCad 2006 to
Excel XP - SP3 the numbers are not useable. All #'s (not text) have an (')
in front of them, excel will not recognize the #'s for functions and will
not recognize the symbol for a find and replace command.
|
|
| Back to top |
|
 |
uNkulunkulu
Guest
|
| Posted:
Tue Aug 30, 2005 12:10 am Post subject:
Re: Attribute Extraction to Excel |
|
|
"Larry" <larry@lkfire.com> wrote in message
news:11h6vnhamv3eg37@corp.supernews.com...
| Quote: | When I open up an excel sheet that has been extracted from AutoCad 2006 to
Excel XP - SP3 the numbers are not useable. All #'s (not text) have an (')
in front of them, excel will not recognize the #'s for functions and will
not recognize the symbol for a find and replace command.
|
Export as CSV file |
|
| Back to top |
|
|
zenboom
Guest
|
| Posted:
Tue Aug 30, 2005 12:10 pm Post subject:
Re: Attribute Extraction to Excel |
|
|
"Larry" <larry@lkfire.com> wrote in message
news:11h6vnhamv3eg37@corp.supernews.com...
| Quote: | When I open up an excel sheet that has been extracted from AutoCad 2006 to
Excel XP - SP3 the numbers are not useable. All #'s (not text) have an (')
in front of them, excel will not recognize the #'s for functions and will
not recognize the symbol for a find and replace command.
|
You should be able to Find and Replace those _'_ out, in Excel, and set
those cell formats to 'Number'
--
R'zenboom
|
|
| Back to top |
|
|
Larry
Guest
|
| Posted:
Tue Aug 30, 2005 4:10 pm Post subject:
Re: Attribute Extraction to Excel |
|
|
Find and replace does not work - even done a copy and paste to make sure the
symbol was exactly right.
"zenboom" <?signal.ds?@?bluebottle.com?> wrote in message
news:df1g4q$6k1$2@ctb-nnrp2.saix.net...
| Quote: |
"Larry" <larry@lkfire.com> wrote in message
news:11h6vnhamv3eg37@corp.supernews.com...
When I open up an excel sheet that has been extracted from AutoCad 2006
to
Excel XP - SP3 the numbers are not useable. All #'s (not text) have an
(')
in front of them, excel will not recognize the #'s for functions and will
not recognize the symbol for a find and replace command.
You should be able to Find and Replace those _'_ out, in Excel, and set
those cell formats to 'Number'
--
R'zenboom
---
avast! Antivirus: Inbound message clean.
Virus Database (VPS): 0535-0, 08/29/2005
Tested on: 8/30/2005 7:22:17 AM
avast! - copyright (c) 1988-2005 ALWIL Software.
http://www.avast.com
|
|
|
| Back to top |
|
|
Larry
Guest
|
| Posted:
Tue Aug 30, 2005 4:10 pm Post subject:
Re: Attribute Extraction to Excel |
|
|
This worked for the drawing I am on, any ideas why excel does this. I have
been on machines that work fine with excel files.
"uNkulunkulu" <izulu@kya.kamina> wrote in message
news:O%LQe.34182$5m3.27031@fe1.news.blueyonder.co.uk...
| Quote: |
"Larry" <larry@lkfire.com> wrote in message
news:11h6vnhamv3eg37@corp.supernews.com...
When I open up an excel sheet that has been extracted from AutoCad 2006
to Excel XP - SP3 the numbers are not useable. All #'s (not text) have an
(') in front of them, excel will not recognize the #'s for functions and
will not recognize the symbol for a find and replace command.
Export as CSV file
---
avast! Antivirus: Inbound message clean.
Virus Database (VPS): 0535-0, 08/29/2005
Tested on: 8/30/2005 7:22:03 AM
avast! - copyright (c) 1988-2005 ALWIL Software.
http://www.avast.com
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in