Go Back   Computer Forums > General Computing > Hardware
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 09-12-2008, 06:48 AM   #1
In Runtime
 
sherwood's Avatar
 
Join Date: May 2008
Posts: 282
Send a message via AIM to sherwood Send a message via MSN to sherwood
Default Nothing in to 0 in excel.

Hey all,

I am wondering if you can help me.

In excel I would like it so blank cells will turn into '0'.

Also I would like it so cells which has numbers in apart from '0' to turn into a color.

If any of you can help me I would be greatful.
__________________

__________________
my rig: Foxconn M7VMX Series|Intel Core 2 Duo E7200GHz|2.00GB of RAM|500GB Western Digital SATA HDD|500GB Hitachi SATA|500GB Maxtor External|Nvidia GeForce 8 Serise 512MB.|400W power supply.|Windows Vista Ultimate|19" HD Monitor
sherwood is offline   Reply With Quote
Old 09-12-2008, 07:46 AM   #2
xxcobraxx
 
Join Date: Oct 2004
Location: England
Posts: 6,224
Default Re: Nothing in to 0 in excel.

I have no idea how to use the program but here are a few questions and answers that may help you

http://www.mrexcel.com/qa.shtml
__________________

__________________
Liveleaker
IAntDemo is offline   Reply With Quote
Old 09-12-2008, 05:32 PM   #3
In Runtime
 
sherwood's Avatar
 
Join Date: May 2008
Posts: 282
Send a message via AIM to sherwood Send a message via MSN to sherwood
Default Re: Nothing in to 0 in excel.

Thank you very much. In the end I turned for 0 so it left blank spaces and also I used conditional formatting for the colour changing on the number.
__________________
my rig: Foxconn M7VMX Series|Intel Core 2 Duo E7200GHz|2.00GB of RAM|500GB Western Digital SATA HDD|500GB Hitachi SATA|500GB Maxtor External|Nvidia GeForce 8 Serise 512MB.|400W power supply.|Windows Vista Ultimate|19" HD Monitor
sherwood is offline   Reply With Quote
Reply

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
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 03:49 PM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0