Changing Negative Sign from Back to Front

D

dipin.puri

I have a large set of data, most of it being numerical. In one column
however, the data imported was imported with negative values having
the negative placed at the end of the number. (ie 2314-, 543-) as
opposed to (-2314 or -543). Does anyone have a quickfix for this
problem?
 
K

KARL DEWEY

Backup your database. Do update like this --
"-" & Left([YourField],InStr([YourField],"-")-1)
 
Top