Converting Text to Number

[ZZ top]

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

 

[Khoshravan]

A1=12 (text not value)
B1=A1*1 or A1+0 (value not text)

multiply the cell to one or add zero to a cell. Results will be numeric.
This is based on the fact that if you conduct an arithmetical action on a
text cell, the result will convert to number format.

 

[Pete_UK]

Can you describe your data layouts in a bit more detail (with
examples), and post the formulae that you have tried?

Pete

 

[ZZ top]

The problem is that this is a text string of the formula. It gives me a
Value! error when I try to convert it using your fix. It still needs to be
able to grab the data from the other sheet. Any other ideas??

Thanks,