Code to format Numbers

[howard]

I am looking for VBA code the will convert numbers that appear with a minus at the end of the number for eg 2,384.34- to be be converted to a negative in front of the number for eg (2,384.34)

See Example below

Your assistance will be most appreciated

Volvo Parts Statement Template.xls
	K	L	M	N
2	4,384.21	97
3	2,384.34-	97
4	1,457.38	25-
5	31.4	25-
6	2,140.09	25-
7	6,450.84	25-
8	2,228.08	25-
9	846.45	25-
10	164.79	25-
11	77.52	25-
12	12,323.74	25-
Sheet1

 

[howard]

Thanks for the info, much appreciated