Removing ' From A Cell

[Minitman]

Greetings,

I have a lot of cells that are using '0.00 to show as no hours. I
have since modified my formula to make this '0.00 obsolete. I just
need a 0 in that cell instead. When I try to do a Find and Replace I
get an error message saying:

Microsoft Office Excel cannot find the data you are searching for.

Is there any way to look for this '0.00 in Excel?

Any help would be appreciated.

TIA

-Minitman

 

[Gord Dibben]

Minit

Try this......

Format an empty cell to General.

Copy that cell.

Select all cells to modify. Format as General.

Paste Special>Add>OK>Esc

Gord Dibben Excel MVP

 

[RagDyeR]

If they're in columns, you can quickly and easily eliminate them by simply
opening and closing TTC.

Select the data, then
<Data> <Text To Columns> <Finish>
And you're done!
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Greetings,

I have a lot of cells that are using '0.00 to show as no hours. I
have since modified my formula to make this '0.00 obsolete. I just
need a 0 in that cell instead. When I try to do a Find and Replace I
get an error message saying:

Microsoft Office Excel cannot find the data you are searching for.

Is there any way to look for this '0.00 in Excel?

Any help would be appreciated.

TIA

-Minitman

 

[Myrna Larson]

Nice one! How did you ever discover that?

 

[Ragdyer]

By accident.
With <Back> grayed out, and <Cancel> not, ever wonder why there *is* a
<Finish> on that first page?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

Nice one! How did you ever discover that?

 

[Minitman]

Cool - That worked great!

Thanks RagDyeR

-Minitman

 

[Ragdyer]

Thanks for the feed-back.

 

[Gord Dibben]

Good trick RD.

Saves a few steps.

Gord