Greetings all,

Maybe you've seen this one before. I'm exporting numbers from a database.
They always export as text. One report I recently worked on had minus
symbols after the number and I need to remove the false symbols. Not all
cells have them so "=right(" formula won't work.

Example.. All numbers are in A column, lets say, and the formula goes in
the B column.

1012.32
-1506.98
5032.56
3651.01-
-3562.54
7463.66-
6373.66

My desired result is a formla that would remove the last character in the
cell, but only if it's a " - ",

1012.32
-1506.98
5032.56
3651.01
-3562.54
7463.66
6373.66

Once again, thank you for all your help.
Mike






--
Mike
Jacksonville, Florida