|Oct 21, 2007, 04:25 AM||#1|
"numbers" zero value?
Is there any way to say if a cell's value is zero, then do not display the zero ? I want to make a spreadsheet look a lot tidier but all the unused calculation values show zeros and I'd rather they displayed a blank.
Sorry if this sounds complex. I cannot think how to simplify this and have tried searching on apple's support for this
|Oct 21, 2007, 04:50 AM||#2|
|Oct 21, 2007, 06:57 AM||#3|
Ah, that is perfect. Thanks Still getting used to moving things from Excel.
It would be nice if Apple fixed the bug whereby numeric keyboards on European computers (who use comma as decimal place) work !
|Thread Tools||Search this Thread|
|thread||Thread Starter||Forum||Replies||Last Post|
|Advanced Search starts with lots of "random" numbers as keywords||simsaladimbamba||Site and Forum Feedback||6||Feb 18, 2014 10:32 PM|
|Apple buffing up "usage" numbers to fool it's users?||Ashin||iOS 6||75||Feb 24, 2013 07:15 PM|
|Numbers "1" and "-" Not Working on Keyboard (tried 3 different sreens)||irepair505||iPhone||1||Feb 4, 2013 03:19 PM|
|Old phone numbers coming up in Autofill "to" field in messages||richardc1983||iPhone Tips, Help and Troubleshooting||1||Oct 2, 2012 04:35 PM|
|iPhone: Old phone numbers coming up in Autofill "to" field in messages||richardc1983||iOS 6||1||Oct 2, 2012 04:34 PM|
All times are GMT -5. The time now is 02:37 AM.