Problem with format of cells?

  • Thread starter Thread starter Roger Thompson
  • Start date Start date
R

Roger Thompson

Hi,

I am using a worksheet that loads data referenced to another separate
worksheet, ie contents of cell equals data inputted to location in other
worksheet. I am now finding that instead of the data appearing in the cell
(e.g. 1234) I am getting the location of the data appearing (e.g. =data!A100
) I am sure that this is just a problem with cell formatting but can someone
point me in the right direction please?

Thanks
 
Try Tools > Options > View tab under the Windows Options uncheck the Formulas
box

Elisabeth
 
Roger, I once had a similar problem which turned out to simply be that I had
pressed Ctrl key and the key to the left of number 1 before saving my file.
This combination 'shows' all formulae. When I opened it up next time it still
showed all the formulae. Pressing this combo might help.
Steve Thompson
 
Thanks for the replies, have tried both suggestions and they do replicate the
problem across the whole worksheet, but the problem I have is trying to edit
the cell location of the data source for individual cells, as i say if I try
and edit the data so that the source location is different E.g. changing data
source from =data!A100 to =data!A150 then the location (=data!A150) appears
rather than the data in that location.
 
The cell may be formatted as text. Try changing it to General and then
select the cell and press F2 and then ENTER.

Elisabeth
 
Well done Elisabeth, your advice has solved the problem completely. I had
tried reformatting the cells to General but had not pressed F2, what does
pressing F2 actually do?
 
F2 allows you to edit the contents of the cell and in this case it also
"refreshes" the cell to conform to the new formatting. It seems like
something that should automatically happen without the F2 intervention, and
yet...just one of the quirks we have to live with I guess.

Glad it worked.

Elisabeth
 
Pleased you're sorted Roger. Elisabeth, thanks for info re F2. I'll bear that
in mind in future :)
Steve Thompson
 
You must log in or register to reply here.

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 Highlighting duplicates 0
Vlookups and formats 3
Conditional Format with Name Range? 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Referencing a cell's data & format in Excel 2004 for Mac 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
For Joey2004 et al. From OP: Re Appending Question 3
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2

Back
Top