Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #742 Sep 12, 2012 www.energyefficientbuild.com.
user outlaw26r said: (http://productforums.google.com/forum/?zx=4yq9wcrgo0dm#!category-topic/docs/spreadsheets/hmFjPVy_M24)
Splitting Data cell results in 0 being removed from front of number (0178)
I am taking calendar data from my team that I have extracted from Google Calendar & I plan on weekly importing into my spread sheet titled Time Tracking Data Dump. I am then splitting the text in A:A to isolate the project number which will come before the ":" into columns F:G. This will enable me to pull all the relevant calender items that match the project number to another spreadsheet. My issue is that when I split the cell as seen in Column F3:G3, the project number is there, but it is missing the 0 in front of the 0178. This is crucial as I am already calling from several other spreadsheets by the project number so I can't just loss the 0.
-----------------------------------------------------------------------------
following is a solution to the problem
user outlaw26r said: (http://productforums.google.com/forum/?zx=4yq9wcrgo0dm#!category-topic/docs/spreadsheets/hmFjPVy_M24)
Splitting Data cell results in 0 being removed from front of number (0178)
I am taking calendar data from my team that I have extracted from Google Calendar & I plan on weekly importing into my spread sheet titled Time Tracking Data Dump. I am then splitting the text in A:A to isolate the project number which will come before the ":" into columns F:G. This will enable me to pull all the relevant calender items that match the project number to another spreadsheet. My issue is that when I split the cell as seen in Column F3:G3, the project number is there, but it is missing the 0 in front of the 0178. This is crucial as I am already calling from several other spreadsheets by the project number so I can't just loss the 0.
I have attempted to change columns A:A & F:F to plain text in hopes of retaining the true number but so far have not been successful. Any ideas would be greatly appreciated.
Thank you,
Outlaw26r
Justin
-----------------------------------------------------------------------------
following is a solution to the problem
No comments:
Post a Comment