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.

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 oog...@desertweyr.com 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

[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 00number Any ideas? Eugenie

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

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

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 joeconner2...@gmail.com wrote: cell-format-number. In the format code bar near the bottom input cell format as 00. without the quote marks. You

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 b.m.bar...@btinternet.com 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

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 b.m.bar...@btinternet.com 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

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