Ok

F2 puts you in Edit mode... it forced recalculation of the formula...

Suggest you try the VLOOKUP solution... it is easier and will save you lot
of effort in future...
You should learn to use it even if you don't use it for this particular sheet.

"Dawn" wrote:

I had tried changing the format to "general" but that alone didn't work. The
hit F2 then enter did the trick. I am not sure what the F2 button did, but
the combination of changing the format to "general", hit F2, the enter to
recalculate did the trick.


"Sheeloo" wrote:

I think that was the first suggestion (from BOB) you had got

"What is the formula? It doesn't sound as though the column is too narrow.
Check the format in FormatCells as well, it should be General. "

"Dawn" wrote:

That fixed it! Thanks!!!!

"Dave Peterson" wrote:

If a cell is formatted as text and is between 255 and 1024 characters long, then
you'll see those #'s.

Try changing the numberformat of the cell to General (or anything but text) and
then hit F2 followed by enter to reevaluate the formula.

Dawn wrote:

I am editing a formula in my worksheet which returns the correct result. As
soon as I make a change to the formula the cell shows the result as
"#######....", but the formula tollbar shows the correct result which is two
initials, "DH". I cannot fix the cell to show the correct result of "DH"
instead of the "##########...".

Has anyone else had this problem? Autocalculate is on, the formating for
the cell is correct. I am at a loss.

--

Dave Peterson