Hi Gary, If you use the excel notation "00"#, you get your 2 leading zeros. But you're right, it's a bug. The formatting should be right automatically. For once, the MS notification is right ;-)
Met vriendelijke groeten, Salutations distinguées, Kind Regards, DRIES FEYS CORPORATE SERVICES • Specialist Software Developer TVH GROUP NV Brabantstraat 15 • BE-8790 WAREGEM T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com Watch our company movies on www.tvh.tv On 18 September 2014 11:25, Gary Collins <[email protected]> wrote: > Hi, > Wikipedia defines leading zero as follows: > > "A leading zero is any 0 digit that comes before the first nonzero digit in a > number string in positional notation.[1] For example, James Bond's famous > identifier, 007, has two leading zeros." > > However, if I put '7' in a cell and select format 2 leading zeroes, I get > '07'. > LO gives one leading zero too few. > > > /Gary > > -- > To unsubscribe e-mail to: [email protected] > 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 -- **** DISCLAIMER **** http://www.tvh.com/glob/en/email-disclaimer "This message is delivered to all addressees subject to the conditions set forth in the attached disclaimer, which is an integral part of this message." -- To unsubscribe e-mail to: [email protected] 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
