yogi_Sum Up Numbers After Importing CSV-File

                                          Google Spreadsheet   Post  #1337
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug, 17 2013
user PooBoy (http://productforums.google.com/forum/?zx=urjhu9nw87rq#!category-topic/docs/spreadsheets/eGQK67SVT1I)
After Importing CSV-File, containing numbers not usable
Hello,

I imported a CSV-File with "tab-stops" as delimiters. The sheet seems to look proper. But when trying to use the numbers (i.e. for summing up), it fails.

A zero is shown.

When I edit the cell with the number it works. The edit is only inserting a space behind the number and removing it.

Is something going wrong during the import process?

Here is the sheet and the original file I used:

https://drive.google.com/folderview?id=0BzLu7DKO6Ku3b21SVmtDZ2NPV2c&usp=sharing

Thank you very much for you help!

Best

PooBoy

PS: is my other stuff on my GoogleDrive safe, which I did not share with the provided link above?

---------------------------------------------------------------------------------------------------------------------------------------------------