In Excel how do you create a macro to similuate keystrokes. If I have a set of data 123.00- and the needs to be put in front, In Lotus I would normally write a macro like this: edit,bs,home,-,enter but in Excel it changes the numbers as you go down the list? I tried changing from absolute but it still copied the numbers from the previous cells?