Hi Jpriddy,

Assuming your data in cell A1 you can put following formula in cell A2,

=RIGHT(A1,1)&REPLACE(A1,LEN(A1),2,"")

H S Shastri

==++++++++++++++++++++++++++++++++++++++++++++++++ +++

"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?