AutoCAD Electrical Forum
Welcome to Autodesk’s AutoCAD Electrical Forums. Share your knowledge, ask questions, and explore popular AutoCAD Electrical topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Importing from spreadsheet

2 REPLIES 2
Reply
Message 1 of 3
CAD-ICE
360 Views, 2 Replies

Importing from spreadsheet

Hi there,

I´m using ACADE2013.

When importing from spreadsheet I have inserted some values on the Rating2 attribute that have fractions like 5,2 etc..

When I import the values back from spreadsheet the value on my drawing are shown with 4 decimals like 5,2000 (see attached image). I´m sure that this has something to do with some settings either in Excel og Autocad Electrical.

Anyone have a clue what´s causing this behaviour ?

Thx, regards, Gary

2 REPLIES 2
Message 2 of 3
rhesusminus
in reply to: CAD-ICE

Hi Gary.

 

I can't reproduce this here, with AcadE 2013 and Excel 2013 Preview.

If you try to "force" the value to be a text value and not a numerical value, does this help?
You can do this by adding an apostrophe in front of the value in excel.

Like this:

 

'2,5

 

 


Trond Hasse Lie
AutoCAD Electrical and EPLAN expert
Ctrl Alt El
Please select "Accept Solution" if this post answers your question. 'Likes' won't hurt either. 😉
Message 3 of 3
CAD-ICE
in reply to: rhesusminus

Hi RhesusMinus... and sorry for the late reply.

Thank´s for the advice but somehow it doesn´t help changing the format  of the cell to a textvalue.

I´m using Excel 2007 and that might be the cause of this issue.

I´m seeing some strange issues with ACADE2013 especially regarding database issues for instance when using the import/export utility.

I´m upgrading soon to a new pc...hopefully these issues will vanish when that´s over Smiley Happy

 

Regards, Gary

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report

”Boost