I'm trying to add the absolute number formula =ABS(C2) to my spreadsheet. When I type the formula into, lets say D2, to reference C2 who's number is -99 it will return 99. But my problems is when I try to copy and paste special the formula down to other cells. When I paste the formula to other cells they all return 99 even if they have a different number. If I copy the formula down to D3,D4,D5 and so on, they will all continue to reference C2 instead of C3,C4,C5 respectively.

I've tried doing the same thing on a new spreadsheet and I can get it to work but not on my spreadsheet which has some standing information on it that will be there every time the user opens the sheet and is used to run the macro. The reason I reference this is because I thought maybe the problem is due to a formatting issue but everything seems normal.

Any ideas??????