That worked...Thanks! Out of curiousity what did that do?

"Gary''s Student" wrote:

Put a single apostrophe before your text before the find/replace.
--
Gary's Student


"kbreiss" wrote:

I have my cell as "text"... here is an example of what is in the cell...

08-10-20-00-00-00

I need to do a Replace....Replace -00 with (leave it blank)
Excel then converts my number to 8/10/2020
Where as I want it to display as 08-10-20

Please help and thanks in advance,
Kacy