Try text to column on that column. Click finish as soon as the wizard pops
up. That should return a result instead of the formula.

"Tom@WardAir" wrote:

The result shows in the formaula calualtiuon but not in the actual cell. How
do the result to display in the cell? I have changed formating to all text,
but I get nothing but formula. Won't calculate for some reason. Help!