Cell Data

  • Thread starter Thread starter Clay
  • Start date Start date
C

Clay

I want to be able to have the same data that is in one
cell appear in another cell. For example, I want the data
that is in cell B72 to also appear in cell J73. I enter
=B72 in cell J73 but nothing changes. The data that is in
cell B72 is text that reads 4-1.
 
Do you see the formula [=B72] in cell J73 ?
If you do try this:
Select J73,
<Ctrl> <Shift> <~>
Then <F2>
Then <Enter>

If you now see the [4-1] data that is in B72, that means that J73 was
formatted as text.
You must make sure that cells in which you will enter formulas are formatted
General *BEFORE* you enter the formula.
 
Hi Clay,

Check to make sure calculation is set to automatic.
Tools>Options>Calculation

Biff
 
First make sure that the B72 cell is set up in text format.
From thr FORMAT dropdown, click on CELLS, click the NUMBER
tab and select TEXT.
 
Thanks - that worked !!!!!!!
-----Original Message-----
Do you see the formula [=B72] in cell J73 ?
If you do try this:
Select J73,
<Ctrl> <Shift> <~>
Then <F2>
Then <Enter>

If you now see the [4-1] data that is in B72, that means that J73 was
formatted as text.
You must make sure that cells in which you will enter formulas are formatted
General *BEFORE* you enter the formula.
--
HTH,

RD

---------------------------------------------------------- -----------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------- -----------------
Clay said:
I want to be able to have the same data that is in one
cell appear in another cell. For example, I want the data
that is in cell B72 to also appear in cell J73. I enter
=B72 in cell J73 but nothing changes. The data that is in
cell B72 is text that reads 4-1.
Click to expand...

.
Click to expand...
 
Back
Top