= sign has no significance.

G

Gary Adamson

I have a sheet that if I put in =A1 in the cell then the
cell shows the value for A1 (ie "TEST"). I have other
cells though that when I fill in =A1 it shows "=A1". How
can I fix this?
 
F

Frank Kabel

Hi
check the format of these cells. It is probably 'Text'. If yes change
it to 'General' and re-enter the 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

Function for summing or counting cells based on a specified fill color 3
=substitute 2
VB code. If statement between two values 1
Help with an if then scenario 2
Definition dynamic minverse 0
VBA for Dependents shortcut menu 0
Show a cell's formula in text format in a linked cell 2
Automatically populating cells down a row 8

Top