I posted this question once before but the answer didn't solve my problem.
I have a spreadsheet that I pulled values from a second worksheet. I was
trying to pull the formulas down the screen to copy and repeat for the next
set of data. Unfortunately the cell numbers didn't increase if I used $
preceding the cell. If I didn't use $ preceding the cell, the numbers jumped
dramatically because it was a set of data.

I was able to resolve that problem by converting the Cell formulas to text.
Then I was able to pull the formulas down the screen to copy and they stayed
in sequence. Now however, I can't get the text to change back to numbers
without doing a mass text to number format change, and then individually
clicking in each cell and then leaving for the values to return.

It was suggested that I could pre-format a group of cells that matched my
data to number and then do a copy, and paste special, values. This did not
work however.

Any other ideas??

Thanks