Deleting "0.000"

[NP]

I am working with a spreadsheet that ranges from column
a -??. There are 10,,000 lines on the worksheet. Within
this range are values of 0.000's.

Each line has a formula and someone is responsible for
analyzing the data. Because of all the 0.000's the
worksheet is not user friendly on the eyes.

I am trying to find a formula that will delete all the
0.000 at one time. Because of the formula being used I
would prefer not to format 0.000 (#) or hide them.

 

[David]

NP,
Try Find & Replace ([Ctrl] + {H})
Find<0.000>
Replace <leave empty>
Replace All
You should find blank cells where the 0.000s used to be
Cordially,
David

 

[Rekoj]

-----Original Message-----
I am working with a spreadsheet that ranges from column
a -??. There are 10,,000 lines on the worksheet. Within
this range are values of 0.000's.

Each line has a formula and someone is responsible for
analyzing the data. Because of all the 0.000's the
worksheet is not user friendly on the eyes.

I am trying to find a formula that will delete all the
0.000 at one time. Because of the formula being used I
would prefer not to format 0.000 (#) or hide them.






.

One thing that you could do is use Conditional Formatting.
Use it to say that whenever that value is met, format the
text as white. White text on White background will make
the text invisible.

Rekoj

 

[Akshay Bakhai]

This will not work (in my view) if the 0.000 in a cell is
there as a result of a formula.

If it works, then the risk is that the formula in the cell
is lost.

I prefer the solution (which I noticed was already posted
by Rekoj) is to use conditional formatting to set the cell
to have white text on white background when the value of
the cell is 0.

-----Original Message-----
NP,
Try Find & Replace ([Ctrl] + {H})
Find<0.000>
Replace <leave empty>
Replace All
You should find blank cells where the 0.000s used to be
Cordially,
David

-----Original Message-----
I am working with a spreadsheet that ranges from column
a -??. There are 10,,000 lines on the worksheet. Within
this range are values of 0.000's.

Each line has a formula and someone is responsible for
analyzing the data. Because of all the 0.000's the
worksheet is not user friendly on the eyes.

I am trying to find a formula that will delete all the
0.000 at one time. Because of the formula being used I
would prefer not to format 0.000 (#) or hide them.






.

.

 

[Ken Wright]

OK, now I'm confused. Akshay, are you also NP??? If so then I thought you said you didn't want
to hide the 0s. If that's not what you meant then it is probably much easier to just do Tools /
Options / View Tab / Uncheck Zero Values.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------

This will not work (in my view) if the 0.000 in a cell is
there as a result of a formula.

If it works, then the risk is that the formula in the cell
is lost.

I prefer the solution (which I noticed was already posted
by Rekoj) is to use conditional formatting to set the cell
to have white text on white background when the value of
the cell is 0.

-----Original Message-----
NP,
Try Find & Replace ([Ctrl] + {H})
Find<0.000>
Replace <leave empty>
Replace All
You should find blank cells where the 0.000s used to be
Cordially,
David

-----Original Message-----
I am working with a spreadsheet that ranges from column
a -??. There are 10,,000 lines on the worksheet. Within
this range are values of 0.000's.

Each line has a formula and someone is responsible for
analyzing the data. Because of all the 0.000's the
worksheet is not user friendly on the eyes.

I am trying to find a formula that will delete all the
0.000 at one time. Because of the formula being used I
would prefer not to format 0.000 (#) or hide them.






.

.