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
Bookmarks