formula not replaced by value

B

Babu

Friends

Some time formula will not be replaced by values
as shown below, even after hitting 'ENTER'
What may be the reason


A B C D

+BS ^ =CONCATENATE(A1,(REPT(C1,31-
LEN(A1))),B1)
SUBID 000000000013 ^

Thank you
Babu
 
S

Svetlana

Your cell with the formula is probably formatted
as "text". Try to change it to at least general.

(Just in case: Format (menue) -> Cell... -> Number (tab) -
Select "General" from "Category")
Click to expand...

Hope this helps,
Svetlana
-----Original Message-----

Friends

Some time formula will not be replaced by values
as shown below, even after hitting 'ENTER'
What may be the reason


A B C D

+BS ^ =CONCATENATE(A1,(REPT (C1,31-
LEN(A1))),B1)
SUBID 000000000013 ^

Thank you
Babu


------------------------------------------------
[/url]
~~View and post usenet messages directly from http://www.ExcelForum.com/

.
Click to expand...
 
B

BrianB

1. A formula must start with = (equals sign)
2. The formula might be written wrongly (what actually appears in th
cell ?)
3. The cell may be formatted as text - when you see the formula instea
of its value
 
B

Babu

Brian

A,B,C,D are column names
D contains the formula
I changed the format of the cell from "Text" to "General"
It starts with "="
In the dialog window value appears
not in the work sheet
Is there any other setting I've to do?
Please help, it's driving me crazy.....

Thanks
Babu
 
P

Paul

Babu said:
Brian

A,B,C,D are column names
D contains the formula
I changed the format of the cell from "Text" to "General"
It starts with "="
In the dialog window value appears
not in the work sheet
Is there any other setting I've to do?
Please help, it's driving me crazy.....

Thanks
Babu
Click to expand...

Changing the format from text to general is not sufficient to change a text
string that was already in the cell into a formula. You also need to select
the cell, put the cursor in the formula bar and press ENTER.
 
G

Gord Dibben

Babu

If you are seeing the formulas and not the results, the formula cells could
have been formatted as Text prior to entering the formulas or you are in
Formula View. Tools>Options>View>Formulas. If the former, changing format to
General will not do the trick.

Select the cells with formulas showing and Edit>Replace

What: =
With: nothing

Replace All.

Gord Dibben XL2002
 
Top