Help? My formula is displaying in my cell

[rsjennifer]

Hi there -

For some reason I have one cell (in a workbook where everything else i
working) that when I type in the formula in the formula bar . . . th
stupid formula is showing up in the cell.

My formula is simply this:

=Info!B13

Because I am taking text from a sheet labeled Info in cell B13. I'v
done this for about a million cells in this workbook so far an
everything else has worked. This one stupid cell is just showing m
the formula.

Can anyone give me some suggestions to fix that?

Much appreciated!
Thanks!
Jennife

 

[David McRitchie]

Hi Jennifer,
Try the following
- Check the cell format, you do not want it to be text
format, cell, general
- Make sure there is no apostrophe in front
- Make sure you are not in formula view
- Retype the content or hit F2 then Enter, but
make sure before hitting Enter there is no space or anything
that looks like a space before or after the formula

Take a look at
http://www.mvps.org/dmcritchie/excel/join.htm#debugformat