One quick way that'll work if you're using xl2002 (I think it was added in
xl2002) or higher:

Select the column.
Data|text to columns
On step 3 of the wizard, click the Advanced button
Check the trailing minus for negative numbers.
and finish up.

Liz J wrote:

I have a column that has both negative and positive numbers. All of the
negative numbers, however, have the negative sign to the right of the number
instead of at the front. For example "3,445.45-" instead of "-3,445.45."
How do I get the negatives to switch to the front of the number? Is there a
formula or a format available?

Thank you for all of your help!

--

Dave Peterson