Editing a formula
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
|