Prev: Icon Sets - Display icon in one cell depending upon value in a
Next: SUMPRODUCT to substiute array formula
From: Lake Oswego on 26 Feb 2010 01:06
Formulas which used to calculate, then disappear leaving only the answer, now
remain without showing the answer. If I replace = with =, it works but only
in that case. How can I get back to normal?
From: T. Valko on 26 Feb 2010 01:40
It sounds like the cells are formatted as TEXT.

Change the format to GENERAL.

Then, select the cell and either double click or hit function key F2 then
hit Enter.

If you have a bunch of cells to convert...

Select all the cells in question
Change the cell format to GENERAL
With the cells still selected
Goto the menu Edit>Replace
Find what: = (equal sign)
Replace with: = (equal sign)
Replace All

--
Biff
Microsoft Excel MVP


"Lake Oswego" <LakeOswego(a)discussions.microsoft.com> wrote in message
news:C6E17FAB-C50B-4D10-8CD8-565F16713F51(a)microsoft.com...
> Formulas which used to calculate, then disappear leaving only the answer,
> now
> remain without showing the answer. If I replace = with =, it works but
> only
> in that case. How can I get back to normal?


From: Lake Oswego on 26 Feb 2010 02:34
Excellent work! I did convert that column to text because I was getting
desperate about my Match not working and was trying everything. I have found
several people who have experienced two cells that look and smell the same
but Match won't treat them as the same. We have to be talking about some
hidden formatting that causes Exact to see a difference when we don't.

"T. Valko" wrote:

> It sounds like the cells are formatted as TEXT.
>
> Change the format to GENERAL.
>
> Then, select the cell and either double click or hit function key F2 then
> hit Enter.
>
> If you have a bunch of cells to convert...
>
> Select all the cells in question
> Change the cell format to GENERAL
> With the cells still selected
> Goto the menu Edit>Replace
> Find what: = (equal sign)
> Replace with: = (equal sign)
> Replace All
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "Lake Oswego" <LakeOswego(a)discussions.microsoft.com> wrote in message
> news:C6E17FAB-C50B-4D10-8CD8-565F16713F51(a)microsoft.com...
> > Formulas which used to calculate, then disappear leaving only the answer,
> > now
> > remain without showing the answer. If I replace = with =, it works but
> > only
> > in that case. How can I get back to normal?
>
>
> .
>
From: Arvi Laanemets on 26 Feb 2010 04:30
Hi


"Lake Oswego" <LakeOswego(a)discussions.microsoft.com> kirjutas sõnumis news:
D47E04A4-A302-49B7-B17D-BA5BE8759566(a)microsoft.com...
> Excellent work! I did convert that column to text because I was getting
> desperate about my Match not working and was trying everything. I have
> found
> several people who have experienced two cells that look and smell the same
> but Match won't treat them as the same. We have to be talking about some
> hidden formatting that causes Exact to see a difference when we don't.


No formatting can affect the real content of cell.

Probably you have some trailing or leading spaces in some cells. Or some
other characters which look like spaces. Or some 'hard returns'/'line
feeds'. And there is a minor possibility that some character in cell is
typed using different code (p.e. unicode character is used instead ordinar
one).


Arvi Laanemets

From: Arvi Laanemets on 26 Feb 2010 05:20
An Example about cahracters looking same but being different:
A <> Α
The first one is ordinary A (ASCII code 65)
The second one is different (unicode character with code 913)


Arvi Laanemets



 |  Next  |  Last
Pages: 1 2
Prev: Icon Sets - Display icon in one cell depending upon value in a
Next: SUMPRODUCT to substiute array formula