When copyijng data from the USDA database
(http://www.nal.usda.gov/fnic/foodcomp/search/index.html) into CALC, there is a
problem where CALC insists on auto-formatting the input and it causes an error.

Sequence:
Open this link (http://www.nal.usda.gov/fnic/foodcomp/search/index.html) and
choose any food.

Now highlight the data, and copy it into CALC.  Everything works fine except in
the "LIPIDS" identifiers, in the first column.  Sample column from Bananas:

Lipids
Fatty acids, total saturated 	
4:0 	
6:0 	
8:0 	
10:0 	
12:0 	
14:0 	
16:0 	
18:0 

Once that data is in the fields, it gets converted into a "time" value so that
4:0 becomes 04:00:00 AM.  No attempt to change the data into 4:0 by defining the
data as text data works, and even if the whole column is defined as text data,
CALC still insists on auto-formatting 4:0 and similar values into time values. 
The manual work around is to enter '4:0.  Tis is a major problem if large
anounts of data are being studied.  It would be better if CALC re-displayed the
data as it was pasted in once the auto-formatted time value was switched back to
text.  A better solution would be:
1)User selects column to be used for data.
2)User selects column and the selects "Format Cells"
3)User selects "text"
4)All data pasted into a column is displayed verbatim,with no conversions.