Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Reply
 
Thread Tools Search this Thread Display Modes
Old Oct 21, 2007, 04:25 AM   #1
m2uk
macrumors regular
 
Join Date: Jan 2004
Location: Finland
"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
Thanks
m2uk is offline   0 Reply With Quote
Old Oct 21, 2007, 04:50 AM   #2
Analog Kid
macrumors 68020
 
Analog Kid's Avatar
 
Join Date: Mar 2003
Quote:
Originally Posted by m2uk View Post
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
Thanks
One way is to apply a conditional format and set the text color to be the same as the background color if the value equals zero...
__________________
Only trolls use the word "fanboy".
Analog Kid is offline   0 Reply With Quote
Old Oct 21, 2007, 06:57 AM   #3
m2uk
Thread Starter
macrumors regular
 
Join Date: Jan 2004
Location: Finland
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 !

Thanks again.
m2uk is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
thread Thread Starter Forum Replies Last Post
Best Value All In One Printer (For Ink and Printer Cost)? ag227 Mac Peripherals 7 Jan 13, 2012 09:21 PM
Iphone value drop bs2511feist iPhone 7 Oct 15, 2011 10:11 AM
"Numbers" Formatting Conversion jusacruiser Mac Applications and Mac App Store 6 May 2, 2011 12:35 AM
Why I can not put value into input button? youlichika Web Design and Development 5 Nov 5, 2010 05:57 AM
Apple "Numbers" -need help getting started macstatic Mac Applications and Mac App Store 20 Jul 3, 2009 05:53 AM


All times are GMT -5. The time now is 02:27 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC