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.
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
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
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
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
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
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
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
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