no functions resolve when format of cells is text
Nothing !
= sign replaced with = sign ... then click "Replace All".
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"laura_in_abq" wrote in message
...
Didn't understand the find/replace suggestion... what do you put in the
"replace" field after the equal sign.
"RagDyer" wrote:
You're having this problem because the cells you're entering your
formulas
into were *PRE*-formatted to Text.
You can fix it several different ways, here's a couple:
If the "bad" formula cells are in a column, you can simply open and close
TTC.
Select the cells, then, from the Menu Bar:
<Data <TextToCoklumns <Finish
If the cells are random, use "Edit & Replace".
Select the cells, then, from the Menu Bar:
<Edit <Replace
In the "Find What" box, enter an equal sign ( = ),
In the "Replace With" box, enter an equal sign ( = ) -YES, same = in
both,
Then click <Replace All.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"laura_in_abq" wrote in message
...
The purpose of this worksheet is analyzing content of strings of
telemetry
displayed as hex characters,in particular parsing and comparing . So
I've
set the cell format for each cell to "text". Because otherwise hex
string
012e3, will be displayed by Excel as 1.20E+4.
The problem: If
content of cell A1 is DEF987
and
content of cell A2 is =A1
then
A2 displays exactly the three characters, =A1 ... rather than the
expected
DEF987. In other words the function in A2 is not resolving, but just
displaying the function. Ditto with other functions, e.g.,
=MID(A1,1,2);
or
=SUM(1,100); or TODAY(). I have Excel 2003 SP3.
thanks.
|