Cell Data

C

Clay Leath

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.

Please help !!!!!!!!!

Clay
 
B

BrianB

Format J73 as text before you enter the formula.

Regards
BrianB
=================================
 
J

Jeff K

Try formatting cell J73 as a number.

If Cell J73 was formatted as text at some point, then
excel is not "viewing" =B72 as a formula.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Cell Data 4
About IF and summing IF over multiple spreadsheets 3
Cell data entering slow! 0
How to adjust chart auto'ly as new data is entered? 2
Edit VBA 4
Word macro that can call cells out of Excel for a find and replace 0
Need Help with a VBA subroutine 0

Top