Hi!

One way:

Select the cells in question
Goto DataText to Columns
Just click straight through: NextNextFinish

That'll convert the TEXT entries like "23-" to negative numeric values -23.

Biff

"brefed15" wrote in
message ...

Perhaps this is a silly question, but i just can't figure out how to
format this worksheet. The problem is that a lot of the cells have
numbers in them with negative signs in the back instead of in the front
(ie. 23-) and i was wondering if anyone knew of a macro/formula i could
use to quickly fix this problem for all the cells. I would be extremely
grateful. Thanks!!!


--
brefed15
------------------------------------------------------------------------
brefed15's Profile:
http://www.excelforum.com/member.php...o&userid=35573
View this thread: http://www.excelforum.com/showthread...hreadid=553341