Format the cell as General and re-enter the formula.
If you post again, do supply the formula.

--
Kind regards,

Niek Otten

"Bonnie W." <Bonnie wrote in message
...
I was trying to take off hyphen within a text string, such as
"0100-00-000".
I used LEFT formula to return the first 4 digit. Then I used RIGHT formula
on the same cell to return the last 3 digit but somehow the formula
doesn't
work. It won't give me a error message but just keep my formula in the
cell.

Please help and thanks