Re: [libreoffice-users] Can't get leading zeros in Calc

2014-06-10 Thread Oogie McGuire
> 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

Re: [libreoffice-users] Can't get leading zeros in Calc

2014-06-03 Thread William Drago
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

Re: [libreoffice-users] Can't get leading zeros in Calc

2014-06-01 Thread Alan B
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

Re: [libreoffice-users] Can't get leading zeros in Calc

2014-05-31 Thread Brian Barker
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

Re: [libreoffice-users] Can't get leading zeros in Calc

2014-05-31 Thread Jay Lozier
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

Re: [libreoffice-users] Can't get leading zeros in Calc

2014-05-31 Thread ZP
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.

Re: [libreoffice-users] Can't get leading zeros in Calc

2014-05-31 Thread Oogie McGuire
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

Re: [libreoffice-users] Can't get leading zeros in Calc

2014-05-31 Thread Joe Conner
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

Re: [libreoffice-users] Can't get leading zeros in Calc

2014-05-31 Thread Brian Barker
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

[libreoffice-users] Can't get leading zeros in Calc

2014-05-31 Thread Oogie McGuire
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)