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

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.
--
R. Khoshravan
Please click "Yes" if it is helpful.


"ZZ top" wrote:

> 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

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

Pete

On Feb 18, 6:09*pm, ZZ top <ZZ...@discussions.microsoft.com> wrote:
> 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 didnot
> work however.
>
> Any other ideas??
>
> Thanks

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,

"Khoshravan" wrote:

> 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.
> --
> R. Khoshravan
> Please click "Yes" if it is helpful.
>
>
> "ZZ top" wrote:
>
> > 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