Control Find/Replace Excel 2000 1

[MJamison07]

I have a column with information like the following in each cell:

BBT01-34
BBT01-35
BBT01-36

I want to remove the "BBT" portion only. I was using the Find/Replace function in this way:
Find - BBT
Replace - (left blank)
Hit Replace all
it turns the cell format to date and I get this:

Jan-34
Jan-35
Jan-36
Is there anyway around this?

Thanks
Martha

 

[bluedragon2]

Yes, instead of a blank space in the replace, put a ' and it will retain its text attribute.