Do you want XL to treat the result as a number or text?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I have a text field with a '('.
ex: 125 108(130

I want to replace the '(' with a '/' without changing the format of the
field to a fraction so my result would be '125 108/130' instead of changing
it to
'125.8307692'

Would appreciate any help someone could give me.