Hi Mary,

welcome to LO!

try this:

 * right click on the cell(s) in question
 * Choose "format cells"
 * when the options appear you want to be in the "Numbers" tab
 * set "Leading zeroes" to 0

I think this is what you are after. BTW, pls respond to [email protected] to reach the largest number of people.

Cheers


On 29/01/15 06:21, Cico wrote:
Dear Mary Sandlin,
I'm forwarding your mail to [email protected]
The list [email protected] is for the libreoffice website 
maintenance only, not for user support.
Refer to this page for more:



http://www.libreoffice.org/get-help/mailing-lists/

Please be aware that if you're not subscribed to the
[email protected] mailing list, you will not receive replies (unless 
replies are sent directly to your mail address of course).
Namastè cico :)


----- Messaggio originale -----
Da: Sandlin Enterprises <[email protected]>
A: [email protected]
Cc:
Inviato: Mercoledì 28 Gennaio 2015 18:55
Oggetto: [libreoffice-website] New to Libre Office

Just got LibreOffice and have a problem.  Have been using excel for many years
and now using calc.  My problem is keeping the formula from printing a zero in
my spreadsheet.  I use this for my invoices and when a line with a formula is
not used (no entry) the result prints as a zero.  How can I keep the zeros from
printing?

Thank You,

Mary Sandlin

--
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/website/
All messages sent to this list will be publicly archived and cannot be deleted



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

Reply via email to