I need to paste data into Excel from OMNIStation to do roll-ups on specific fields. But OMNIStation designates negative
numbers with a minus sign at the end of the number (e.g., "$10,236.60-"). So, I tried recording a macro to remove
the minus sign at the end and put it at the beginning, at which point Excel then recognizes the number as a negative value.
Problem is, Excel doesn't record the keystrokes, rather it is recording the contents of the cell...
' Keyboard Shortcut: Ctrl+a
ActiveCell.FormulaR1C1 = " $10,236.60"
That means when I run the macro on the next negative value cell it just copies the same value into that cell. Not much help.
Is there a way to get Excel to record the actual keystrokes and not treat this as a formula?