Excel - FUNCTIONS aren't working like before

Asked By DogmaDo on 14-Jan-09 10:20 AM
I am attempting to use some text functions in a file.  They are not working
like they do in another file.  Could I have inadvertently flipped some sort
of a switch in this one file?

JE McGimpsey replied on 14-Jan-09 10:29 AM
Quite possibly!

But it is entirely impossible to tell unless you give *some* detail about
what formulae you are using and what "not working" means to you...
DogmaDo replied on 14-Jan-09 11:46 AM
I am trying to edit text fields in a .csv file I got via email.  I open the
attachment with notepad, save it as a .csv file.  I am trying to use the find
function like
Column A
Column B
Row 1                    =FIND(" %",B1,1)	2008ApJ%677%37O

Row 2                     =text(B2,"000")	                2 (a number)

When I type the FIND in the cell then enter, the cell still has the function
in it.  Same for the TEXT function.

However when I try the same things in another file the result is fine.
This file was also a .csv file

B                                    C
Row  	EXAMPLE	                 RESULT	                        Function
1	       43	                                    043
2	       GI4_043001_GW_Lib	      4	                 =FIND("_",B2,1)

Hope you can understand my rather primative attempt to depict a worksheet.

JE McGimpsey replied on 14-Jan-09 11:51 AM
You've probably formatted A1:A2 as Text, so XL's parser doesn't try to
interpret the formula.

Format the cells as General, and re-enter.

Alternatively, you could have inadvertently typed CTRL-` (on the same
key as the tilde), which toggles the Formulas window Option. Type it
again to see the result of the formula.

In article <6765C27C-F2B7-46A3-9989-9FE680F2906F@microsoft.com>,
Pete_UK replied on 16-Jan-09 02:50 AM
J E,

on my (UK-style) keyboard the ` key is the extreme top left (above the
TAB key), whereas the tilde (~) is a shifted # (next to the Enter


ome sort
en the
the find
Column A =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0
=A0 =A0 2008ApJ%677%37O
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 2 (a number)
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0C =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0 =A0
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 Function
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 043 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=3DFIND("_",B2,1)
JE McGimpsey replied on 14-Jan-09 12:25 PM
Yeah, I should have said "on US keyboards..."

OTOH, with a name like DogmaDot, what are the odds that the OP is *not*
from the US - the last best bastion of dogma...

Thanks for the correction.

In article