Wednesday, January 22, 2014

yogi_WorkAround For Restoring Entries In-Situ MisInterpred By Google Old Sheets As Currency Entries

                                          Google Spreadsheet   Post  #1492
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-21-2014
question by MrHoudini (http://productforums.google.com/forum/?zx=umogbowmaaqk&usp=sheets_web#!category-topic/docs/spreadsheets/Upov-wyWE0g)
Stupid Google Sheets changes my data.
I have a csv file that contain warehouse locations for items. These locations are FT101, FT102, etc.

When I import the file into Google Sheets, it changes them all to F101, F102, etc.  That's bad enough, but it gets worse.

When I then use importrange to pull the data into another sheet, it drops the Ft altogether.  So what should be FT101, FT102, etc, is now  101, 102. 

WTFIUWT?

How can I get Sheets to stop guessing what I want done and leave my data as is?

HELP
---
The problem is there is no work around, only a waiting game till the new sheets can do importrange.  And if they "bring all of the features from old sheets to new sheets" including the automatic currency misinterpretation, I'll be forced to find another solution, which is unfortunate since we are a GA for business customer relying more and more on Google's products.
------------------------------------------------------------------------------------------------