right() not working

  • Thread starter Thread starter urbanist1100
  • Start date Start date
U

urbanist1100

I just upgraded to Excel 2003, and when I type in =right
(A2,10), what appears in that cell is just "=right
(A2,10)" (instead of the result!!). What is going on
here? Any help appreciated!
 
Is the cell formatted as text?

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Is this happening in all the cells with a formula?
You might have accidentally hit Ctrl+` (back quote).
Tools/Options/ View tab, check if Formulas is checked.

Also check the formula bar to see if accidentally you have
entered an apostrophe (') before the formula. This will
make everything text and the apostrophe will not appear in
the cell.
 
Tools > Options > View, and uncheck "Show Formula"

or

CONTROL+` (backtick, next to the 1 key)

Hope this helps!
 
I checked - on some other cells in the same sheet, at
least a simple =E2+F2 (on number cells) works fine. I
checked also re. ' before the formula, but nothing. It
seems like the formula is just not being recognized,
although when I start to type =right( the formula cue box
displays "right(text,[numchars])". If I had to guess I'd
say that there is some module I have to load, but I
haven't been able to find anything, and it seems that in
general these text functions should be installed
automatically. --I did also check that the cell in
question is a text cell - it is.

thx,
mystified
 
Actually, I just figured out a workaround - copied the
data into a new sheet first as format only then as values
only. There appears to have been something wacky with
those particular cells (although I downloaded this file
as a csd - ??). Anyway, it's working now. Thanks everyone!


-----Original Message-----

I checked - on some other cells in the same sheet, at
least a simple =E2+F2 (on number cells) works fine. I
checked also re. ' before the formula, but nothing. It
seems like the formula is just not being recognized,
although when I start to type =right( the formula cue box
displays "right(text,[numchars])". If I had to guess I'd
say that there is some module I have to load, but I
haven't been able to find anything, and it seems that in
general these text functions should be installed
automatically. --I did also check that the cell in
question is a text cell - it is.

thx,
mystified
-----Original Message-----
Is this happening in all the cells with a formula?
You might have accidentally hit Ctrl+` (back quote).
Tools/Options/ View tab, check if Formulas is checked.

Also check the formula bar to see if accidentally you have
entered an apostrophe (') before the formula. This will
make everything text and the apostrophe will not appear in
the cell.


.
Click to expand...
.
Click to expand...
 
Hi
goto 'Format - cells' and check your format. If it is 'Text' change it
to 'General' and re-enter your formula

--
Regards
Frank Kabel
Frankfurt, Germany

I checked - on some other cells in the same sheet, at
least a simple =E2+F2 (on number cells) works fine. I
checked also re. ' before the formula, but nothing. It
seems like the formula is just not being recognized,
although when I start to type =right( the formula cue box
displays "right(text,[numchars])". If I had to guess I'd
say that there is some module I have to load, but I
haven't been able to find anything, and it seems that in
general these text functions should be installed
automatically. --I did also check that the cell in
question is a text cell - it is.

thx,
mystified
-----Original Message-----
Is this happening in all the cells with a formula?
You might have accidentally hit Ctrl+` (back quote).
Tools/Options/ View tab, check if Formulas is checked.

Also check the formula bar to see if accidentally you have
entered an apostrophe (') before the formula. This will
make everything text and the apostrophe will not appear in
the cell.


.
Click to expand...
Click to expand...
 
Back
Top