
	Applies To

	Product(s):	ProSteel 3D Professional
	Version(s):	08.11.11.55
	Environment:	N\A
	Area:	General
	Subarea:	N\A
	Original Author:	Detlef Hackbarth, Bentley Technical Support Group

Background

The Prosteel Data can be exported to MicroSoft Excel but two "specials" have to to observed.

Steps to Accomplish

1. Specials with the export from ProStructures

Starting from the dialogue ProStructures Partlist menue Delivery you choose a *.lst-format e.g. for groups. In the following mask you can simply choose Direct to... MicroSoft Excel Format (red frame):

This will be the result:

The format will be "crowded" and hardly usable within Excel. Therefore select Options (green frame) and choose "Only data from table object(s)" from the tab Output:

The table will contain the plain data from your partlist - but oooh! The numbers are signed with an error indicator (green triangle) and in text format! They're not countable!

2. Editing the data within Excel: Use the Paste Special Command (from http://support.microsoft.com)

1.In any blank cell, type the value 1.

2.Make sure the cell you typed 1 in is formatted as a number.

3.Select the cell in which you typed 1, and then right click and choose Copy.

4.Select the cells with the values that you want to convert to numbers.

5.Right click and choose Paste Special.

6.Under Operation, click Multiply and then click OK

Thereafter:

7.Leave the cells selected; right click and choose Format cells…

8.On tab Number select Category: Number

External Links

Bentley Technical Support KnowledgeBase

Bentley LEARN Server

Comments or Corrections?

Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!