| View previous topic :: View next topic |
| Author |
Message |
Windmiller
Joined: 24 Jun 2005
Posts: 1716
Location: Chapel Hill, NC
|
 Posted: Sun Sep 13, 2009 3:33 pm Post subject: Google Spreadsheets |
 |
|
I am using Google Spreadsheets and it wont allow sspecs with the SK prefix along with a 0.
SO SK086 ends up as Sk 86. I have tried removing validation and changing validation but still no go.
Does anyone else know how to get around this? |
|
| Back to top |
|
 |
Cpuswe
Joined: 15 Mar 2005
Posts: 2214
Location: Karlskrona, Sweden
|
| Posted: Sun Sep 13, 2009 3:56 pm Post subject: Re: Google Spreadsheets |
|
|
| Windmiller wrote: | I am using Google Spreadsheets and it wont allow sspecs with the SK prefix along with a 0.
SO SK086 ends up as Sk 86. I have tried removing validation and changing validation but still no go.
Does anyone else know how to get around this? |
It must have to do with what format the data in the column is as default setting. Probably is formated as numbers not text. When you enter 086 it formats it as 86 since 086 is the same as 86.
Try to format it as "Plain text" using the button marked "123" in the toolbar. That worked when i tried in a new document.
_________________
My collection: http://www.cpucollection.se :::::: http://www.chipdb.org Photos of chips you never knew existed. Now over 6000 different chips in the database. |
|
| Back to top |
|
|
Windmiller
Joined: 24 Jun 2005
Posts: 1716
Location: Chapel Hill, NC
|
| Posted: Sun Sep 13, 2009 4:06 pm Post subject: Re: Google Spreadsheets |
|
|
| Cpuswe wrote: | | Windmiller wrote: | I am using Google Spreadsheets and it wont allow sspecs with the SK prefix along with a 0.
SO SK086 ends up as Sk 86. I have tried removing validation and changing validation but still no go.
Does anyone else know how to get around this? |
It must have to do with what format the data in the column is as default setting. Probably is formated as numbers not text. When you enter 086 it formats it as 86 since 086 is the same as 86.
Try to format it as "Plain text" using the button marked "123" in the toolbar. That worked when i tried in a new document. |
Thanks Thomas! I looked everywhere and somehow overlooked that.
Yes, if you change to plain text it works...whew |
|
| Back to top |
|
|
CPUShack
Joined: 16 Jun 2003
Posts: 34259
Location: State of Jefferson, USA
|
|
| Back to top |
|
|
|
![[ Hidden ]](https://cdn.cpu-world.com/forum/templates/CPUWorld/images/lang_english/icon_email.gif "[ Hidden ]"){kind=icon}
