Function in Tempalte

B

Boris Mohar

Hello,

I have function =(B1*20) in column C in my Template.
When I import data:

Data> Import External Data,

My data is the tab delimited bill of materials I set it up so that there is a
blank entry for column C I expected that after data import the column C
will contain whatever number was in column B times 20

The only imports available are Edit Text import and Data range properties.
Others are grayed out.

I select Edit Text Import and go with the defaults. At this point data gets
imported and the column C function gets overwritten with a blank

What to do or what not to do?
 
Top