Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Delete 0's in Excel

Posted on 2012-03-23
2
Medium Priority
?
500 Views
Last Modified: 2012-03-23
I have a column (C) with a lot of numbers in it. How can I have excel delete all the cells that have a 0.00 value? I just want the cell deleted not the whole row. Any idea?
0
Comment
Question by:cansevin
2 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 2000 total points
ID: 37759883
Select the data
Do      Data > Filter
From the dropdown at the top select only 0.0
select the zeros
press the delete button
0
 

Author Closing Comment

by:cansevin
ID: 37759891
You the man, thanks!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

926 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question