Hello Tom, On Sat, 4 Jun 2011 15:22:50 +0100 (BST) (your time) you said:
> ... i played around with "Format Cells". I couldn't get an ideal answer > that shows a - even when the cell is empty but i could get one when the > cell has 0 value. Well, too much time later and I haven't been able to work it out either, Tom. Even if you do get a "-" to show up in an empty cell (using COUNTBLANK for example), it still isn't useful because "-" in a time formatted cell always results is '#VALUE!'. I clearly don't know enough to be able help here. :-) -- Si (PLO) #31064. Now Hew Sore Dig? ¶ Auxiliary Information: • LibreOffice 3.4.0 OOO340m1 (Build:12) • Windows XP Pro 5.1.2600 Service Pack 3 -- Unsubscribe instructions: E-mail to [email protected] In case of problems unsubscribing, write to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
