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.
Typically I read the cell, convert to string, pad with the
appropriate number of 0's, then write to the database.
-Bill
On 5/31/2014 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 number to properly show up as 00<number>
Any ideas?
Eugenie (Oogie) McGuire
Desert Weyr, LLC - Black Welsh Mountain Sheep http://www.desertweyr.com/
LambTracker - Open Source SW for Shepherds http://www.lambtracker.com
Paonia, CO USA
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted