Hi everyone!

I am new to this forum and also to Excel's Macros (VBA) itself, but really do need help so any input would be much appreciated.

I am in the process of creating a spreadsheet that will assist me with my work.

Within the spreadsheet I have a range of cells, for example: "E3:E100" that contain figures such as "100.00D, 50.00C" and so on. These are "Credits(positive)" and "Debits(negative)". As you will all be aware, by having 'Alphanumeric' characters within the cells the figures within the column will not calculate. I want to create a button on the spreadsheet that will once clicked remove the letter from the end of the cells and add a "-" to the left of the negative values (that initially contained the 'D' at the end).

Thank you in advance!