Saturday, August 17, 2013

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:

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?
---------------------------------------------------------------------------------------------------------------------------------------------------

No comments:

Post a Comment