Maybe I'm not doing this correctly...The first data point is cell J2, with
6,476.52-

When I enter your formula, changing to J2, i get an error relating to a
circular reference.

"Luke M" wrote:

If first data point is in A2:
=IF(RIGHT(A2,1)="-",-VALUE(LEFT(A2,LEN(A2)-1)),VALUE(A2))

Formula checks for minus sign, if found, create negative number, if not
found, a positive number.
Copy formula down/across as desired. Then at end, I'd recommend copying the
cells with formula, and right-click/paste special "values" to where ever you
want to data to ultimatley go.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"jpriddy" wrote:

I have a report uploaded to excel from a particular program used here at
work. In that program, negative numbers have the format of $###.00-, with
the minus sign at the end instead of the beginning. When the data comes over
to Excel the minus sign is still at the end of the number. I have been
manually moving the minus signs to the beginning in each cell which is very
time consuming. Is there a formula I can use in the Cell, Column and/or
Worksheet containing these numbers to globally change them at once?