> OK an update:
The original spreadsheet is an export of a .XLS file from a Foxbase database on
a Windows machine. Based on what I got I thought the data were stored as 4
digit numbers but in the database they are really 6 or more text characters.
I needed to get it into an SQLite Database on
To preserve leading 0's in a spreadsheet type the number
with an apostrophe before it. For example, instead of typing
1234, type '001234. That will preserve the leading 0's.
If I don't care about formatting in the spreadsheet, I'll
add the leading 0's in the code that does the passing.
Typica
On Sat, May 31, 2014 at 7:34 PM, Oogie McGuire
wrote:
> I'm tearing my hair out here.
>
> I have a spreadsheet and the data was originally entered as 4 digits. I
> need to pass it to a database system that requires 6 digits. I've tried
> formatting with 2 leading zeros but I still cannot get the
At 13:02 01/06/2014 +0800, Zonly Ponly wrote:
On Sun, 01 Jun 2014 01:11:36 +0100 Brian Barker wrote:
At 17:34 31/05/2014 -0600, Oogie McGuire wrote:
I have a spreadsheet and the data was originally entered as 4
digits. I need to pass it to a database system that requires 6
digits. I've tried f
On 06/01/2014 01:02 AM, ZP wrote:
On Sun, 01 Jun 2014 01:11:36 +0100
Brian Barker wrote:
At 17:34 31/05/2014 -0600, Oogie McGuire wrote:
I'm tearing my hair out here.
Don't!
I have a spreadsheet and the data was originally entered as 4
digits. I need to pass it to a database system that r
On Sun, 01 Jun 2014 01:11:36 +0100
Brian Barker wrote:
> At 17:34 31/05/2014 -0600, Oogie McGuire wrote:
> >I'm tearing my hair out here.
>
> Don't!
>
> >I have a spreadsheet and the data was originally entered as 4
> >digits. I need to pass it to a database system that requires 6
> >digits.
Already tried that, it doesn't work. I tried a custom format 00 but still
only get 4 digits.
On May 31, 2014, at 6:17 PM, Joe Conner wrote:
> cell->format->number. In the format code bar near the bottom
> input cell format as "00." without the quote marks.
> You can adjust the zer
On 05/31/2014 04:34 PM, Oogie McGuire wrote:
I'm tearing my hair out here.
I have a spreadsheet and the data was originally entered as 4 digits. I need to pass
it to a database system that requires 6 digits. I've tried formatting with 2 leading
zeros but I still cannot get the number to prope
At 17:34 31/05/2014 -0600, Oogie McGuire wrote:
I'm tearing my hair out here.
Don't!
I have a spreadsheet and the data was originally entered as 4
digits. I need to pass it to a database system that requires 6
digits. I've tried formatting with 2 leading zeros but I still
cannot get the num
I'm tearing my hair out here.
I have a spreadsheet and the data was originally entered as 4 digits. I need to
pass it to a database system that requires 6 digits. I've tried formatting with
2 leading zeros but I still cannot get the number to properly show up as
00
Any ideas?
Eugenie (Oogie)
10 matches
Mail list logo