I type $1000 in cell D31. I type =D31+50 in cell D32 because I want D32 to show $1050. I then want to copy that formula into the next 100 cells in row D so that the value in each cell is $50 higher than the one before it. This is a bookkeeping exercise, so I need each cell to have a dollar sign.

However, when I do this, I get the #VALUE! error and I can't figure out why. I'm aware there are other ways to achieve this, but I need to know why this particular way isn't working. Many thanks.