Hello Spencer,
You can create a Module within you workbook and paste the below code. To do this press the F11 key while holding down the Alt key. Go to insert and then select Module. Paste the code here. Now Exit out of Visual Basic (alt+Q) and press the F8 key while holding down the Alt key. You should get a macro pop up box. Highlight the Macro, Macro1, and then select the options button on the right. Here you can assign a shortcut key to the Macro. So that it will add the equals sign to the beginning of the cell.
Sub Macro1()
'makes a note of the original contents of the cell you have selected
Set actcell = ActiveCell
'adds the equal sign to the beginning of the cell
ActiveCell = "=" & actcell.Value
End Sub
Please let me know if you have any questions.
Thanks,
RVASQUEZ
Bookmarks